Jump to content

link databases


jbeltran

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

Recommended Posts

  • Newbies

I have been racking my head over this and the best way to do this.

I need to link two databases (contact, invoice) and transfer information from two fields in the contact database over to the invoice database.

Version: v6.x

Platform: Windows 2000

Link to comment
Share on other sites

  • Newbies

I guess I'm not understanding, but here is what I want to do. In the contact database I have two fields for name (first name, Last name) and in the invoice database I have a field Talent which would be like a describsion. On the contact database say when you press a button both the first name and last name from the contact database would transfer into the talent field in the invoice field.

Sorry for the newbie question

Link to comment
Share on other sites

jbeltran,

You don't need a button to do what you want. First you will need to create a relationship(Key Field) in the invoice database. Customer_ID# is what I always use for this. This fields contents will need to match EXACTLY what the Contact database has in it for the lookup to take place. Your 2 name fields will need to be defined as a lookup. As soon as the Customer_ID# field matches one in you Contact file the names will automatically be populated.

HTH

Link to comment
Share on other sites

This topic is 7311 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
×
×
  • Create New...

Important Information

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