I should perhaps have explained that I have a table which links Roles (People in postions in companies) to addresses. This table should allow a particular location (room 101)to...
Thanks for your advice. The problem in having a foreign key on either Person or Organisation is that both can have more than one address. The basic thinking...