link records?

O

Old Grizzly

Hi,
i have a simple database as a catalog of discs. If i have disk 1 of 2 and 2
of 2 is there a way i can link the records so that a selection will indicate
a link of these 2 records?

TIA
Cheers Len
 
D

Douglas J Steele

You could essentially build a linked list by putting a foreign key in the
record. Have the first record point to the second record, the second record
point to the third record, and so on. The last record would have Null in
that field.

In terms of relationships, you'd join the table to itself.
 
Top