link databases

[jbeltran]

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

[Kurt Knippel]

Well and relationship from Invoice to Contact via ContactID would be thw way to go.

[jbeltran]

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

[AudioFreak]

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