5 Replies Latest reply on Mar 30, 2010 8:56 AM by neil45156

    opening another database automatically

    neil45156

      Title

      opening another database automatically

      Post

      Hi Everyone,

       

      There may be a simple answer to my problem, but I have tried a number of ways to get my feature to work, but with no luck. I am using Filemaker v10 on a windows vista.

       

      I have two databases which are linked together with their unique ID number. One is a customer database with customer ID and the other is an invoice database with its own Inv ID. I have built the relationship between custID and custID in the inv database.

       

      What I have been trying to do is write a script which will enable me to have a customer record in the customer database, then run the script which opens the inv database showing the inv for the customer I see in the customer database.

       

      I have used the Go to related record and specified the invoice database from the Get related record from drop down. I have turned on the show only related records and match current records only. However, when I run the script, it works in finding the current record in the Invoice database, but will not open it so I see it in front of me.

       

      Any help would be much appreciated.

       

      Neil45156