Question Relationship Queswtion (1 Viewer)

[danbl]

I have a table with visit date, provider, and date of birth. The primary key is VId and this is the foreign key in the other related tables. All works fine now.

I need to add a table which has the following a date field, which can be any date in the month, hours, and hours with days off.

I am having difficulty coming up with a relationship which takes the information from the visit table and other related tables and links it to the new table.

Can someone pleas help me with this. :banghead:

 

[Pat Hartman]

Tell us what you think the relationship is in words and that should help you decide what will be required as a foreign key.