November 10th, 2006, 02:28 PM
posted to microsoft.public.access.tablesdbdesign
|
|
|
Many-2-many relationships: Can I be told ...
Course table has an employeeID foreign key
"Allen Browne" wrote:
What foreign key do you have?
Does your Course table have an EmployeeID foreign key?
Or does your Employee table have a CourseID foreign key?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"scubadiver" wrote in message
...
Of course they have foreign keys!
I can list all the employees on a given course by using a query.
"Allen Browne" wrote:
Clearly, I have no idea what you are talking about either.
If your tables have no foreign keys, you can do what you like.
"scubadiver" wrote in message
...
But that doesn't mean to say I can't list all the employees who have
taken
a
specific course? If establishing a 1:n relationship between course and
employee means it could be quicker to enter information into a form,
then
there is a trade off.
|