Jump to content
Sign in to follow this  
soriano

Questions about Lookup!!!

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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