I appreciate that this is probably a basic question but I just can't figure it out.

This is an Electronic medical record solution.

I have a table for "doctors" in which each practitioner has a unique id. It is related to a "Location" table that contains the addresses at which each practitioner works and it has a location id. As it is a one to many relationship I have created a join table which contains of course the practitioner id and the location id.

The problem is that each practitioner has a unique provider number for each location. Thus each provider number is dependant on a practitioner and a location.

I have a layout in the practitioner table with a portal to the location table in which I display the addresses for each practitioner.

How do I display the provider number give that it requires two keys, Practitioner id and location id?

The only place that I can see is by adding the provider number to the join table but that field don't display properly if I put it in the portal.

If I place a portal to the join table will this work.

I know that I can have two portals, one to the location table and another to the provider table but this is messy.

I would appreciate any advice.

Joseph

I have a table for "doctors" in which each practitioner has a unique id. It is related to a "Location" table that contains the addresses at which each practitioner works and it has a location id. As it is a one to many many-to-many relationship I have created a join table

If I place a portal to the join table will this work.

Yes, assuming each doctor/location combination has only one record (at most) in the join table.

I'm not sure I follow. Each doctor has a unique id and each location has a unique id.

Many of the doctors work at up to 4 locations, thus in the join file there will be multiple entries for a given doctor id but each entry will have a different location id.

My question is, can I place the fields from the location itable in the portal from the join file to allow me to make new entries in the location table as each doctor a quires a new location.

Similarly, can I place fields from the the provider table which is related by the same join file but a a different relationship in the join portal?

You can place fields from Locations in the portal to the join table. You cannot use this portal to create new records in Locations.

Thank you for your help.

At least now I know that putting fields on a join file is ok even if I can't create a new entry directly