Using Invoice Starter Solutions With Custom Fields, Need Relationship Bw Customers and Products
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.