Solved: How to get the value from referenced table - Page 2

Countryboy_OmEr · 04-17-2020 11:25 PM

I have a table named “Order Details”, it has many columns but two referenced columns relevant here are"Customer Name" and “Area”. What I wanna do, is when in “Order Details” table, I select Customer name from dropdown list of referenced value of “Customer Details” table. Area name available in “Customer Detail” table should be filled automatically in the “Order details” area column. Can you understand me? Please help

Suvrutt_Gurjar

@Countryboy_OmEr ,

It sounds that you are referencing the “Customers Details” table in the “Orders Details” table. In that case you may use the standard method of dereferencing to pull other fields from the Customers table in the orders details table.

For example [Customer Name].[Area] to pull the area from the “Customers Details” table in the “Orders table” where [Customer Name] is rhe reference type column in the “Orders Details” table.

View solution in original post