Portal Relationship Problem...

[tmas73]

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

[Anuviel]

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

[tmas73]

I tried this but it wont work!

Thanks for your time!

[comment]

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".

[tmas73]

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

Thanks

[comment]

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.