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

    Productivity kit



      Productivity kit


      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

          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)