Skip to Content
0
Former Member
Mar 02, 2009 at 05:48 PM

need help getting record(s) from layered tables

18 Views

Greetings,

The company database has what I can only describe as layered tables. Table 1 has a record that references actual data in another table. The data in Table 1 is a numeric reference to the data in Table 2. I need to be able to get the referenced data from Table 2 based on the identifier in Table 1.

Hopefully this makes some sense. I am on a very short deadline having spent the majority of the weekend trying to figure this out.

Any help would be greatly appreciated!!

Thank you,

Martin