Link multiple tables to same field in parent table

L

larpup

I have several child tables that need be linked to the same field in
parent table. Is this a wise or problematic practice?

Lar
 
D

Duane Hookom

Could be very appropriate. For instance an EmployeeID might be used in a
timesheet table to link hours worked with an employee. The same EmployeeID
might be used in a project participant junction type table to link employees
with projects.
 

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

Linking 4 child tables to 1 Parent table 8
Parent Child Tables and Relationships 6
"Multiple Autonumber" in same table 2
Key field question and linking tables. 3
One-to-One Table keys 9
Child table/subform 5
2 databases using the same autoumbers, how can I merge them into 1 7
Multiple subtables 1

Top