I've got an Acess 2000 database with several tables. The main table pulls data in to certain fields from the other tables.
for example, we have a people table with first name, last name, unique identifier, and phone number.
the main table has many fields, two of which are person and relative (there needs to be more). the person and relative fields pull their information from the people table and is a dropdown box where you can choose the person and also their relative. however, currently i only have the unique identifier for both of them in the main table. i would like the main table to show their first name, last name, and phone number.
however, it seems there is a logic problem since both are being pulled from the same table (People).
any insights? if this is confusing I would be more than happy to clarify.
chipy
for example, we have a people table with first name, last name, unique identifier, and phone number.
the main table has many fields, two of which are person and relative (there needs to be more). the person and relative fields pull their information from the people table and is a dropdown box where you can choose the person and also their relative. however, currently i only have the unique identifier for both of them in the main table. i would like the main table to show their first name, last name, and phone number.
however, it seems there is a logic problem since both are being pulled from the same table (People).
any insights? if this is confusing I would be more than happy to clarify.
chipy
