Jump to content

History Letters??


soriano
 Share

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

Recommended Posts

HI,

I have 2 DB (Patients & Letters), I created a relationship to bring the letters to my Patients DB, now, I can't make a portal with a History of all letters sent to a one patient.

Each patient can have many letters.

Could you help me, please??

TKS

Saludos from MEXICO

Jorge S.

Link to comment
Share on other sites

Assuming that these letters are standard or form letters, you need a third file. it has 2 fields, the foreign key that matches the primary key in patients and the foreign key that mtches the primary key in letters. THis is called a many to many relationship.

When that is done, define a calc field in the third file equal to the text of the letter. Place that into a portal in the patients file that is linked to the many to many file.

THen you can see the text of any letter in the patient file. Conversely, if you do this the otehr way around, you can see the name of any patient who received one of the form letters in the letetr file.

HTH

Old Advance Man

Link to comment
Share on other sites

This topic is 7190 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
 Share

×
×
  • Create New...

Important Information

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