i've created a database to handle an insurance form which
deals with the insurance of money. it has a number of
different tables such as 'cust', which lists details of
customers, 'prem', which lists details of where the money is
stored, and 'safe' which lists details of the safes in
Hi Hubert,
If I understand you correctly, you have a many-to-many relationship.
Another example of this is college classes and students --
a student may be enrolled in a number of classes
a class has a number of students enrolled
so you have many-to-many, unlike say an invoice which is
Also, don't confuse a safe type - such as a model designation, with a safe
serial number. You would use a safe's serial number as a primary key in
the safe table, as well as a foreign key in the intersection table Dave
described below. To figure out what type of safe it is, you would need
another
3 matches
Mail list logo