tmas73 Posted February 8, 2002 Share Posted February 8, 2002 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? Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted February 8, 2002 Share Posted February 8, 2002 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 Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.