Linking data

[advance]

I am trying to link data between 2 databases. I have 2 databases joined. Both databases contain part #, description, and cost fields. I want to bring the part # from one record in one of the databases and then have the description and cost fields from the same record fill in the other database. Used repeating panel but it does not link the cost and description to the part number. Seems elementary but i cannot get it to work. What am I doing wrong or overlooking? Thanks for any help.

Advance

 

[suesloan]

To copy the cost and description into your new record, add a "modification formula" to field definition for each of these fields. The formula is simply the name of the field in the joined database that you want to get the value from.

Then, when the part number is filled in, completing the join, the modification formulas will fill in your other fields!

Sue Sloan

http://www.xpertss.com