1 Reply Latest reply on Feb 3, 2010 3:58 PM by davidanders

    Productivity Kit

    veronica1

      Title

      Productivity Kit

      Post

      How do I get my data to work within the productivity kit. It seems like the tables are not connected when I try to look at how the database was built. I imported my contacts into the solution table provided, but I can't get their addresses to populate when I try and create a sales order. The same holds true for adding my products and then trying to calculate inventory. Can anybody help me. I'm not a database developer and need a starting point to start with. Thanks

        • 1. Re: Productivity Kit
          davidanders
            

          If you have two clients - andy andrews and andrea also - the database needs a unique id (identifier)

          Andy would be "AA01" and Andrea would be "AA02".

           

          In the Invoice tab or layout, there would be a field that would need to match the clientID.

          Once "AA01" is entered into that field, Andy's address information would fill in.

           

          Same with Products, they have a unique ID number.

           On the Invoice on line number one, once the Product ID is entered, the cost, description and such would fill in.