Help with Database setup

[WarrenB]

I have a database for an event with 2 main tables.
Parents and Children of the parents with a one to many relationship.
I need to be able add the table number that each parent and child will be at (not the same table as parent). I could add another field for the table to each database but not all the entries are attending the event.

Could someone point me in the right direction as to the best way to design this.

WarrenB

 

[wardster]

Possibly create a 3rd table SeatingAllocation with Name and TableNo as columns, with a union query joining Parent and Child tables to populate a single list of all names which could then be used in a dropdown box...

Ian