I m new in FM, and I m a Doctor and i want to do a data base of my patients in my clinic, so i prepared a table with primary key is the medical file number and i create records of my patients and i want to know that if the the patient came back to my clinic and i put his medical file number, how all his previous data as name and age and address automaticaly reenter in his new record?

Hi

you haven't to duplicate data from previous record !

You need to make a relationship from your BaseTable:medicalNumber and PatientTable:medicalNumber

thank u for ur response, it means that i have to do 2 tables, one for patient medical file numbers and other is patiient data and make relationship?

"one for patient medical file numbers"

That table is your daily working table holding, among other fields, the patient medical file number.

HOW I CAN MAKE RELATIONSHIP THAT WHEN I ENTER THE PATIENT MEDICAL FILE NUMBER IN PATIENT FILE NUMBERS TABLE, ALL DATA FROM OTHER TABLE OF PATIENT INFORMATION AUTOMATICALY REENTERED

This is a simple Idea...

patient.zip

Please do not use All CAP in your posts, it is considered Shouting.

TIA

Lee

i saw ur example and tried to do it same way but doesn't work with me

Hi,

it was a tiny mini-file...

you HAVE to understand it and let it work for you too.

Anyway, read something about relationship in the help on line !

thank u for ur cooperation with u, god bless u, but i tried and i did it in the same way u did but not works with me, i don't know what is wrong, can u tell me plz a site online that help me to train myself in a simple way and in details about tips and tricks in FM8

thanks

Hi manar,

Why not [color:blue]Post a copy of your file, it might be a quicker way to help you. That way we can see your files and do a better job of explaining what is and is not happening.

Lee

Hi manar

yes, Lee was right ! Post your file to the Forum.

It's the best way to make your file to work.

i send the file 2 ur email

this s the file

Can you zip the file, I have no luck with .rar files

Lee

Ok manar

received, modified and resended ! :

this s a zip version of the file

OPHTNALMEMR.zip

thank u Mr raybaudi i rcv the file it s working

thank u mr lee smith, u was great help