I have a relational database with three tables. After I create a new record in the parent table [Artists], I want to create a new item associated with this record in the Prints table.

How do I copy the ID value in the parent table and transfer it to the new record in the prints table?

In the Artist information layout, I have a script attached to a button that is called Add New Print that does the following:

Got to Layout (Prints)

New Record

Set Field [Prints:Artist_ID; Artists::ID]

It creates the new record but does not change the Prints:Artist_ID, therefore the two are not connected. Should I be using a look up value instead of a script that does the set field? Any help would be appreciated.

Thanks so much!

I've attached a screen shot of the relationships graph.

Edited June 19, 200718 yr by Guest

Hi and welcome to the forums. Try this.

Set Variable [$ArtistID; Artists::ID]

Go to Layout [Prints]

New Record []

Set Field [Prints:Artist_ID; $ArtistID]

In your script you are going to the other layout but it doesnt know what to pouplate the field with because there is no related record in Artist. You ahve to temp store it in a variable or global field.

It works great now.

Thank you, Mr. Vodka! You tha man!