AnsweredAssumed Answered

Linking/Looking up data from multiple tables

Question asked by jd2775 on Feb 9, 2009
Latest reply on Feb 10, 2009 by ninja


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.