Let me just clarify your question...

You have a patients file and a letters file and you want to connect the letters file to the patients so that you can send certain letters within the letters file to a patient. yes?

You may want to create a reltionship between the two files using the Letter_name as the link. Create a field within the patients file for Letter_name and format the field using values(Letter_name) from the Letters file. Otherwise, you may want to add more fields within the letters file to link a specific letter to the patient by patientID#. Then the Patient ID# will be the link between the two files and you can also set up a Letters portal in the patients file to view the different letters sent to the patient.

I hope I didn't confuse the issue...

Hi every body:

I have a Pacients DB and another file to create letters,in this file have just two fields (Letter_name and Body_letter), how can I bring a specifc letter to my Pacients DB.

May be it's simple but mt crain it's closed now, thanks for any help.

Gracias

Jorge Soriano

Ok,

Need I create 2 relationships?? One to the letters_name field and 2nd with Pacient_ID???

I need to create the history about letter sent to the pacient, Can I do this??

Thanks,

(It excuses my not well English one)

Jorge Soriano

What Ken is saying is exactly right, you nned to create a relationship from Patient to Letter. In affect this is One-to-Many, because one patient can have severaL LETTERS, BUT A LETTER is always sent on behalf of only one patient, right. So, Patient ID would make sense as Primary Key in Patient, and Foreign key in Latter.

You can then have a text field called Letter History, or create yet another file by the same name, and connect all of them on PatientID.

You must create a relationship both ways if you need to see patient info, such as First and Last name from Letters file.

Hope this is helpful

BikeBoy