Hi every body...

How can I know wich of my records are the primary record to lookup others???

I have a Patients DB, in this I lookup almost 15 fields, at same DB and its related by MotherName field, when I create a new record and select the mother's name, lookup all the fill fields.

But some times do, and some times no, could you help me with these??

For these reason I asked first how can I know which of my records are the primary record to lookup others???

I hope (like many times) your help.

Thanks

Jorge Soriano

Please describe your data base architecture: your primary file and your secondary files.

Hi, Jorge. First of all, it may not be a good idea to base the relationship on the mother's name; what if her name changes? Then your relationships are broken. You're better off using a unique ID/serial number.

To address your question: If these other fields are auto-enter looked-up values based on that relationship, i wonder if they are not being filled in because the relationship is not valid--maybe because the name was not entered correctly? To check this, ignore the looked-up fields for the time being and put related fields on your layout. If those work properly, then the issue is with the lookup.

Jerry

Thanks for your answers!!!

QuinTech...

I related by mother's name due make some reports, and in this case the field have a validation to check that is filled that field, and display a list with all the names in that field...

Transpower....

The relationship is in the same DB:

Mother Name Validation, List (Mother_Name)

Address Auto Enter, Lookup

etc..

Thanks for your help

Jorge Soriano