junction tables

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

can I join existing tables (with data already entered) with junction tables
(and How)
Thanks
 
Junction tables form the "to" section of a many to many relationship.

You would need to give more details of what you are trying to do to get a
workable answer
 
Marie said:
can I join existing tables (with data already entered) with junction tables
(and How)
Thanks
Click to expand...

If, say, you had a table of employees, and table of company vehicles,
you could create what's called an "associative entity" table which
contained (apart from its own primary key) the primary keys of the other
two tables, plus, perhaps, the date the vehicle was adopted by the
driver, and perhaps the insurance policy number.

Phil, London.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Junction table 1
Junction table question 4
Populating Junction tables and/or populating two tables at once 2
many to many relationship/ junction table 2
Junction tables and data entry 4
table design 2
how can i do this 3
Many-toMany relationship 4

Back
Top