4 Replies Latest reply on Feb 27, 2013 2:25 PM by philmodjunk

    Need Help With Relationships

    shample

      Title

      Need Help With Relationships

      Post

           Hi,

           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?

           Thanks!

           Scott

           410-332-6473

            

      Relationships.jpg