2 Replies Latest reply on Sep 2, 2013 8:35 AM by philmodjunk

    automatic related filed entries



      automatic related filed entries


           This probably elementary to a seasoned FM12 user, but can anyone advise me on how to do the following:

           I am a publisher and I have set up database recording the sales of books. i would like to do the following:

           I have a drop-down menu in the book title field. When I select a title I'd like the price for that book to automatically appear in the book price field.

           Finally, is there anyione out there who is a dab hand at Filemaker programming who lives in or near Bristol in the UK?


        • 1. Re: automatic related filed entries

               The database consists of follwing tables

               1. Books - BookId, Title, Price

               2. Sales: SalesId, Date, FK_BookId, BookTitle, BookPrice

               Set parent child relationship between Books and Sales table on basis of Books:BookId and Sales::FK_BookId fields.

               Define Sales table's BookTitle & BookPrice fields as auto-enter calculation field which gets respective fields data from Books table, using relationship. this way when user selects book from dropdown (associated with Sales::FK_BookId field), the data is populated in BookPrice & BookTitle fields.

          • 2. Re: automatic related filed entries

                 Take a look at the Invoices starter solutions that come with FileMaker 11 and 12. Both are set up so that when you select an item on the invoice, the current price for that item is looked up from a products table.