Newbie: Design question
I have a contract that has about 6 fields that need to be filled out each time it is signed. My goal is to have a form that only asks for the missing information then includes that into the contract which is then printed and then stored in a database completed. There would be 3 unique things about each contract. The contractor's name, the contract date, and the "Route#". Can anyone give some quidance as to where I would look for guidance on how to design this? I know almost nothing about SQL. I don't mind if its either a web form ( ideal ) or openoffice document. Troy
Newbie design question
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