I have a problem with my solution, I try to integrated a invoicing product solution. The main problem I have is most likely relationship related, but I cannot figure it out. If I choose a Product in the invoice layout under Product ID and I choose a product it wont populate the information throughout the portal.

Please see attached file.

Log: 1

Pass: 2

I really appreciate any help.

Thanks

Thomas :

Clone9v11_copy.fp7.zip

Uhm, got lost in your file but I would have to say that your line items is not related to your items, something like

SalesOrders::InvoiceID = LineItems::InvoiceID

LineItems::ProductID = Items::ProductID

I tried this but it wont work!

Thanks for your time!

Anuviel is correct, both on the diagnosis and the cure. Your auto-enters are trying to get data from an unrelated TO. You DO have a relationship between LineItems and a TO of Products, but you are not using it in your "lookups".

Thank you! It did work, so the relationship was already set up just the calculation lookup was pointing to the wrong relationship. Right?

Thanks

Yes, I think so. There's a lot of extra stuff in your file that I didn't understand. I prefer having an unbroken TOG going from Customers through Invoices and LineItems all the way to Products. That way you can, for example, place a portal of Products on a layout of Customers to see which products each customer bought.