Basic relationship question using a join file

[eyeguy]

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

[comment]

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.

[eyeguy]

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?

[comment]

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

[eyeguy]

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