To Jamie, Jens Lauritsen, Hans and all of you that follow this thread and came with many helpful suggestions 'Thanks'.

After trying different models, I managed to create a Syntax that allow me to enter data in one field and get automatically related data filled up in two other fields. I had to split the helping REC file into two files. The Key variable in the first file was the brand (say Aspirin) and the second variable was the Generic name (say ASA), and in the second file the Key variable was the generic name and the second variable the ATC code.

If somebody may give a feed back, I will appreciate it.

The two 'Helping files' look like this:

Brand-Generic (MedGen.REC)

MedNvn Aspirin MedGen acetylic salicylic acid MedNvn Beuron MedGen acetaminophen MedNvn Efferalgan MedGen acetaminophen MedNvn Panadol MedGen acetaminophen MedNvn Paralen MedGen acetaminophen MedNvn Tyelenol MedGen acetaminophen

Generic-ATC (MedATC.REC)

MedGen acetylic salicylic acid MedATC n02ba01

MedGen acetaminophen MedATC n02be01

MedGen acetaminophen MedATC n02be01

MedGen acetaminophen MedATC n02be01

MedGen acetaminophen MedATC n02be01

MedGen acetaminophen MedATC n02be01

The CHK file of my qustionnaire (MedicineQues.CHK):

MedNvn

MUSTENTER

COMMENT LEGAL MedGen.rec Show

TYPE COMMENT MedGen

END

MedGen

COMMENT LEGAL MedATC.rec Show

TYPE COMMENT MedATC

END

MedATC

NOENTER

End

(The role of the command MUSTENTER and NOENTER is not fully clear to me, However, they have to be included in this fashion)

The CHK file of the Brand-Generic database (MedGen.CHK):

MedNvn KEY 1 END

MedGen KEY 2 END

The CHK file of the Generic-ATC database (MedATC.CHK):

MedNvn KEY 1 END

MedATC KEY 2 END

My QESTIONNAIRE file (MedicineQues.QES):

MedNvn the name of the Drug ___________________ MedGen The Generic name ___________________ MedATC The ATC code _____________ AnyFild Any field #

*¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-