Linking invoice.dbf to items,dbf

[seg0906]

I would love to be able to write Report Writer Sales reports for MOM that will properly link data between the invoice.dbf table and the items.dbf table. This is how MOM writes it^s internal sales reports - but I"ve been unable to link in such a way that I can get the item specific data to come up properly. ____In my mind you would need to link by both the ORDER field and the INPART field (invoice part) - so you can link up which item go on 123456A and which go on 123456B, and so on. ____I^ve used previous softwares where you could create a new concatenated field in both the items table and then invoice table and link by that field. Can report writer do something like this? I^ve tried some things - but I can never get the item data for an order to link up to the right invoice part. ____Thanks for your help!__Sarah

[kfleming]

TO get from INVOICE to ITEMS, create a calculated field called ORDLINK with the expression:____STR(ORDERNO) INPART____then use this field as the linking field to the related table ITEMS and select the INPART index tag from ITEMS.CDX.____Set the relation as scan to find all of the items for each invoice.____Kathleen__R&R Support__

[beguine]

I am also wanting to link the items table and the invoice table. I created the ORDLINK and I received an error message. My master table is the INVOICE.dbf and the error I get is "Unrecognized name or operator".

[kfleming]

I was missing the + sign.____You need __STR(ORDERNO)+INPART____Kathleen__R&R Support