2 Replies Latest reply on Aug 21, 2012 5:55 AM by philmodjunk

    Add a table to form layout

    galeton

      Title

      Add a table to form layout

      Post

      Hi. I'm working on a book database. I would like to have a table on form view that displays all the titles and authors in the database and be able to click on them to go to the book. I would like it to look like when you click on Filemaker Help and go to the search tab. All the information appears in a list that is clickable. Thank you for your help. I've tried to do it with a portal but only the record that relates to the book appears instead of all the books in the database.

        • 1. Re: Add a table to form layout
          davidanders

          A portal displays related records. You want a Self-Join relationship.

          If you create a global field called gSelfRelateID, put a "1" in the global field.
          Create a relationship between your Table and a copy of the Table (table occurence) using gSelfRelateID.

          Your portal will display a list of found records.

          • 2. Re: Add a table to form layout
            philmodjunk

            Your portal will display a list of found records.

            Actually, your portal will display all records in your table--whether or not they are "found".

            You can also use a relationship with X instead of =. Match on any fields of your table and your portal will list all records in the table.