Ok, maybe this is not possible. Or maybe I asked the wrong way...
Table B and C have information relating to the "working" Table A. i.e. addresses, item numbers etc etc...records that are "fixed". What I want to do is pull certain fields from those 2 tables to go along with certain fields in the update table A, to form these reports. Think of Table A as a "ordering" table. (trying to use inventory examples, though this database is not that at all...but I feel it would make more sense using those terms)
I hope that makes more sense, maybe it doesn't :)
Thanks for the posts, but I must admit I'm not sure what you're after.
Are you asking about how to link three tables together?
Under File>Define>Database, select the "Relationships" tab and you'll see a graphical reference to your tables. Drag the Identifier field from Table A to the corresponding linking field in Table B. A line will show up that connects them and they are now related tables. Do the same for Tables A and C and you're done. (?)
In a layout, you can now put fields from Table B and/or Table C onto a layout associated with Table A and have them populate correctly with the related information.
If this isn't what you're after...please try again. Please keep it simple, but at the same time, give all the pertinent info.