I have a report that is using the ordreline table, but I would like to get some information from the article table, how do I do that ??
First, create a variable of Record type called Article with a subtype of Article. If you know the value(s) of the Primary key in the Article table: Article.GET(orderline.Value); //Where value is the value required to “get” the record based on the primary key. or Article.SETRANGE(FIELDNAME,orderline.value); Article.SETRANGE(FIELDNAME,orderline.value); //…etc. Article.FIND(’-’); //’-’ means the first record matching all of the filters set in the setrange commands. Bill Benefiel Manager of Information Systems Overhead Door Company firstname.lastname@example.org (317) 842-7444 ext 117
This works fine. Thank you very much !