Jump to content

Creating lookups


Darrell
 Share

This topic is 6481 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I hope this the right forum for this question, if it isn't I am sorry in advance, so here it goes. I have DB called invoice. In this DB i have separate fields for Caller name, company, address, city, state,zip. I created a second DB called contact. I then created a relation ship with both these DB using a field called key. In both those fields I put the number 1 in the field. So far I think I am creating a relationship correctly. What I want to do in the invoice DB is when I put in the caller name I want the DB to go to the contact DB lookup the company, address, city, state, & zip and paste it the invoice DB. So each time when I put the called name it the address will come up automatically. Can someone please explain how to do this or is there a better way to accomplish this?

Thanks

Link to comment
Share on other sites

Set up your relationship from the "Invoice" database to the "Contact" database based on the Name field.

Set the address fields as lookups based on the new relationship.

(I like to use a ContactID as the key field to avoid spelling confusion. Is it Sean, Shaun, or Shawn? If the database is very small, you could use a value list to select the names.)

Link to comment
Share on other sites

This topic is 6481 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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