Jump to content

The relationship needed for a portal


This topic is 6606 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've attached the relationship diagram I have for my invoice. Most of it works beautifully to get all the info my users will need. However, I want to relate the quotes relevant to that particular Job No, there may be many. I thought the best way to do this would be to have a portal but I can't seem to find the right relationship to do this.

I've tried relating the tbl quote by job no and quote no to tbl invoice but haven't had any luck. I must be missing something. Any ideas?


Link to comment
Share on other sites

I'm having difficulty following your structure so I will try by this example. I have a table of Patients that could have many Physicians. I then have a table of PhysicianPhoneNumbers, each physician could have many numbers, home, office, pager... To see a portal of all the physicians, you need a relationship to a PhysicianID in Patients to PhysicianID in Physician, lets call it Physician_Patients. Then to see the PhysicianPhoneNumbers, you need a relationship from the PatientID in Physician_Patients to the PatientID in PhysicianPhoneNumbers, called Physician_Patients_PhysicianPhoneNumbers. That way whatever ID is in PhysicianID in Patients will decide which PhysicianPhoneNumbers to show in the portal Physician_Patients_PhysicianPhoneNumbers in a layout from table Patient.

Link to comment
Share on other sites

This topic is 6606 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.