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