Linking/Looking up data from multiple tables
Ok I will try to make this as generic as possible
I have a table. Table A we will call it. This is the main table used for importing records. Once data is imported I need to compose a form that has related data from Table A, B, and C for a report, but only certain fields from each table. I suppose Table A has a "unique identifier" that will be used for this purpose.
My question is, is this something you do via a script? Or should I add a new table with required fields for report, link it to the other tables in question, and then format some command? Based off the unique ID number? What would that command look like?
Thanks for any help.