Need Help With Relationships
I am trying to create an invoice using the invoice starter solution.
I have the four tables: Products, Customers, Invoices, Invoice Data.
Pricing of the product, in the product table, is based upon a field called "pricing category"
Likewise, in the Customer table, the name of the company has an associated "pricing category".
I joined the two "pricing category" through the Invoice and Invoice Details tables.
I cannot get the invoice or invoice details tables to see the relationships I created.
The "pricing category" field from the customer table does not show up on the invoice details form and the drop down boxes don't see it either.,
Do you have any ideas?