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

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

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

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