lookup values in a continuous form

T

Tig

Hi,

I am stuck on this.....

Table 1: person
person_Id
person_name

Table 2: relatives
person_id
rel_id (this would be coming out of person table)

My aim is to store names and the relative names of people.

so my table structure looks like the above. i.e. 1 person has 1 or many
relatives.

I would like to create a continuous form:

person_id person_name relatives
1 john yes (command button to open the
relatives table) yes if there are values in rel_id in table 2 for person_id
1
2 mary yes (command button to open the
relatives table) yes if there are values in rel_id in table 2 for person_id
2
3 joe yes (command button to open
the relatives table) yes if there are values in rel_id in table 2 for
person_id 3
4 don no (no command button) no if
there are no values in rel_id in table 2 for person_id 4

Any ideas on how to do this?

Thanks in advance!
 
Top