I have a master table containing Supplier Code, Part Category & Part Code
I have a parent table ("Supplier Invoice") containing Supplier Code & Supplier Invoice Number
I have a child table ("Supplier Invoice Details") containing Supplier Invoice Number, Part Category & Part Code.
New parts are first added to the Parts master table.
While adding the line item details of an invoice to the child table, I would like to -
What formulas do I add to the Valid_If field?
Solved! Go to Solution.
You may want to mention
1. Through which column the master table and the parent table (Supplier Invoices) are referenced to each other.
2. Through which column the child table Invoices details and parent table Supplier invoices are referenced to each other.
Hello!
The Master table and Parent table are referenced via Supplier Code
The Parent & Child tables are reference via Supplier Invoice Number
Hope this helps
Thanks. Is it correct to assume that in the master table there will be many records for a single supplier code with corresponding Part Category and Part Code?
Similarly, there will be many combinations of one supplier code and a supplier invoice number because each supplier can have multiple invoices?
yes you are right....
Supplier Code - Part Code combination is unique (Category is an additional tag, but can repeat across a supplier or suppliers)
Similarly, Supplier Code - Supplier Invoice Number combination is also unique.
Hope this makes sense.
Please try a valid_if for [Part Category] in child table "Supplier Invoice Details" something like
SELECT( Master Table[Part Category], [Supplier Code]=[_THISROW].[Supplier Invoice Number].[Supplier Code])
For [Part Code] it can be
SELECT( Master Table[Part Code], [Supplier Code]=[_THISROW].[Supplier Invoice Number].[Supplier Code])
You may want to mention
1. Through which column the master table and the parent table (Supplier Invoices) are referenced to each other.
2. Through which column the child table Invoices details and parent table Supplier invoices are referenced to each other.
Hello!
The Master table and Parent table are referenced via Supplier Code
The Parent & Child tables are reference via Supplier Invoice Number
Hope this helps
Thanks. Is it correct to assume that in the master table there will be many records for a single supplier code with corresponding Part Category and Part Code?
Similarly, there will be many combinations of one supplier code and a supplier invoice number because each supplier can have multiple invoices?
yes you are right....
Supplier Code - Part Code combination is unique (Category is an additional tag, but can repeat across a supplier or suppliers)
Similarly, Supplier Code - Supplier Invoice Number combination is also unique.
Hope this makes sense.
Please try a valid_if for [Part Category] in child table "Supplier Invoice Details" something like
SELECT( Master Table[Part Category], [Supplier Code]=[_THISROW].[Supplier Invoice Number].[Supplier Code])
For [Part Code] it can be
SELECT( Master Table[Part Code], [Supplier Code]=[_THISROW].[Supplier Invoice Number].[Supplier Code])
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |