Work request & Work Order - which table should have the foreign key?

M

Mark

I have two tables, tblWorkRequest (Primary field WorkRequestID) and
tblWorkOrder (Primary field WorkOrderID). A work order will not always have
a work request, the majority of work requests will have a Work Order as long
as the request is accepted. It is a one to one relationship as each request
can only have one work order. Is it better to have a foreign key
WorkOrderID in tblWorkRequest or foreign key WorkRequestID in tblWorkOrder?

thanks
 

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

Best way to use the Document Shape 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Primary and Foreign Keys 10
referential integrity and tables 4
Can't join 3
WORD VBA Search and switch to advanced ... 1
Primary Key to Foreign Key 8
Assign Foreign key 2

Top