Dear all, I'm designing a database for a travel company but i'm puzzled.. Maybe you can shed a light on this:
I've got an travelpackage that can exicts of more possible departure date's but it has also have more than one accommodation. So 3 tables: (table one) -Travelpackageid (Primary Key) -Travelpackname etc (table two) -dateid (Primary Key) -date (table three) -accommodationid (Primary Key) -accommodationname etc Must a create 2 Join tables (travelpackageid/dateid and travelpackageid/accommodationid)??? Please help, Frank