3 Replies Latest reply on Mar 7, 2011 9:38 AM by philmodjunk

    Using Invoice Starter Solutions With Custom Fields, Need Relationship Bw Customers and Products

    RebeccaGholson

      Title

      Using Invoice Starter Solutions With Custom Fields, Need Relationship Bw Customers and Products

      Post

      Hello. I need help!

      I have created a db by using the Starter Solution called Invoices.

      I chose Invoices bc it has CUSTOMERS & PRODUCTS, and those are the two I need.

      I changed the names of lots of the fields in the Customer area and the Products area. Now I need to set up a relationship like this:

      My Customer field called VEHICLE WANTED should relate to 3 of my PRODUCT FIELDS: Make, Model and Style.

      (And, the Product fields called Make, Model and Style should also relate to Customer field VEHICLE WANTED.)

      I tried to set up the relationship myself, but couldn't bc when I went to Manage: Databases: Relationships, the fields that it showed didn't include the fields I have added in, and I don't understand how to use tables for this purpose.

      Thank you!