Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Linking multible database files-----HELP


Recommended Posts

Please help!

I have 3 different filemaker database files each of them have a field "Last Name", when I create a new record, I would like the new recod to be created in all 2 database files.


Any Help?

Link to comment
Share on other sites

In Database2, Database3 create fileds

recordIdrelatetoDB1 = [text]


You Need to create 2 relationships


Database1 (recordID) :: Database2 (recordIdrelatetoDB1)

Database1 (recordID) :: Database3 (recordIdrelatetoDB1)


Place fields

:: Database2 (lastname),

:: Database3 (lastname),

in your main database1.


Crete New record script in each database


Database2, Database3 are simple


Script =


New Record Request


In Database1 to be performed as follows


Script =


New Record request

Go to field [Last name]

Show Message ["enter the last name, When complete press the enter button."]

Pause script [ ]

Perform Script (external ::Database2(new record Request)

Perform Script (external ::Database3(new record Request)

Setfield [::Database2(lastname)] [Lastname]

Setfield [::Database3(lastname)] [Lastname]


There this should take care or your problem cool.gif

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use