1 Reply Latest reply on Jan 14, 2010 2:16 PM by philmodjunk

    Productivity kit

    veronica1

      Title

      Productivity kit

      Post

      I'm using the productivity kit as a starting point for a small business database and am having trouble making the connections between contacts and creating a sales order/invoice. It seems like the productivity kit is not showing all the tables it's using. For example, I thought I just needed a contacts table, but it shows connections to a Bill to Contacts and Ship to Contacts. Any help is appreciated.  Veronica

        • 1. Re: Productivity kit
          philmodjunk
            

          Filemaker Databases and their attached documentation frequently use the terms "table" when they should say "table Occurrence".

           

          I don't have that file to look at, but most likely, Bill to Contacts and Ship to Contacts are two table occurrences with the same data source table, Contacts. You can check this in the relationships graph by hovering your mouse over the arrow in the upper left corner of each box.

           

          The difference between them is that you'll see a differnt field in contacts being used to match records.

           

          If you'd like to learn more here's a link to a post I made on the subject:

           

          Table vs. Table Occurrence (Tutorial)