Linked tables
Hello,
I have a table "Customers" who are linked with a table "Invoices" who have a subtable "Items", when I create a new invoice from "Customers" the invoice are linked to the customer but when I'm created a new item from invoice the item are not linked to the customer.
Could you help me please.
Thierry
11 replies
-
I don't think what you asking is the right way.
My way:
Create this formula field Invoice.Customer.Name in Invoice Items table, and every item will has the Name of the customer. Then you can report, group, filter etc.
Nick
-
Your formula work
But the link "Customer" are empty in Items subtable
Here in Invoice table the link Customer are right.
I just want to autofill Customer link in Items subtable.
-
PS Thank you for your help
-
Hi Thierry,
you can create a trigger "on create" in Items-table:
---
let myC:=Invoice.Customer;
Customer:=myC
---
Leo
-
I don't think this is possible, or at least I don't know how...
There are links between:
- Customer -> Invoice
- Invoice -> Invoice Items
- Invoice Items -> Products
but there is NOT: Invoice Items -> Customer.
Look at the data model:
-
I think he has created duplicate linking to the Customer table.
It is not useful but possibleCustomer -> Invoices
Invoices -> Items
Customer -> Items
Leo
-
Thanks Leo for the info...
And, while we are here, can we use more than one "on create" trigger?
Nick
-
Yes Leo, I do it to have a view of items sell directly from customer view
-
@Thierry,
With the new feature "View" you no longer need an additional link.
Formula
---
Invoices.Items
---
@Nick,
You can write several commands with semicolon
Leo
-
Thanks again @Leo,
and "one more thing", the new feature "View" is fantastic!
Nick
-
Leo, it didn't work!
Leonid, fantastic "view" are what I want to see ;)
Many thanks for your help.
Thierry
Content aside
- 6 yrs agoLast active
- 11Replies
- 4466Views