Recent content by captain stag

Pat Superb response, thanks very much

Thanks for the reply. You're right, I do need to keep the company and staff as separate tables (massively different structure/fields). Your final point with two foreign keys will achieve the neccessary functionality (referential integrity etc), but one of the foreign keys will always be null...

I'm trying to create a db to store for example Company Details, Staff Details, and Address Details. Each company may have multiple addresses Each staff may have multiple addresses Each Address is EITHER a company/staff address The address table structure is the same for both Company & Staff I...