Big brain support needed here. Expressions. Ugh

[Jonathan_S]

Good Day everyone

I have 2 slightly frustrating probably minor (“To me Large”) problem.

My Tables

Vendor Table
The following Tables are part of the Vendor Table (Nested Forms)
Vendor Film Table (Vendor Ref from Vendor Table) AKA Film Types to be selected in nested table in Receiving Table
Vendor Display Table (Vendor Ref from Vendor Table) AKA Display Types to be selected in nested table in Receiving Table
Vendor Master Table. (Vendor Ref from Vendor Table) AKA Master Types to be selected in nested table in Receiving Table

Receiving Table (Vendor Referenced from Vendor Table)
The following Tables are part of the Receiving Table (Nested Forms)
Receive Film Table (Vendor Ref from Receiving Table --> [Receiving Forms].[Vendor]
Receive Displays Table (Vendor Ref from Receiving Table -->[Receiving Forms].[Vendor]
Receive Masters Table. (Vendor Ref from Receiving Table -->[Receiving Forms].[Vendor]

The First problem is this.

A user selects a vendor in the Receiving Form, they can than receive different items. (Film, Displays, Masters) all nested in the Receiving Table, When they open a form in the receiving table lets say Displays, they need to select a display type. This will come from the Vendor Display Table.

I need only the Display Types to show for the Vendor that was chosen in the Receiving Table.

I have a column in the Receiving Displays Table Called Vendor which has the currant formula
[Receiving Forms].[Vendor]

For my display name Column I have this referenced to my Vendor Display Table with the Following Formula.

SELECT(
  Vendor Display[Display Name],
   ([_THISROW].[Vendor] = [Vendor].[Vendor])
)

This still seems to show all the display Types there are available with all the vendors, also with a yellow triangle.

Vendor is already Set with the vendor selected in the Receiving Table.

MY Second Issue This.

In my Receive Displays Table (nested in my Receiving Table) I have 2 text columns.

These columns need to be populated from the Vendor Display Table once the display type has been selected.

Column A is: Item Description
Column B is: Look out for the Following

I have Tried [Vendor].[Vendor].[Item Description]. Various variations of this. Nothing seems to work.

Any help would be greatly appreciated.

Thanks,