Newbie: Design question

2003-12-21 Thread Troy T. Hall
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

2003-06-01 Thread Frank Keessen
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