I have 2 Tables - Orders and Customer
Order Table has fields - Customer and Customer ID
What I am trying to do is In Orders Form ( when creating or editing the order) I want to autofill the Customer ID (referring the customers table) upon the selection of the Customer . I tried the LOOKUP but its not working the way it should. Its showing me the customer (name) in the customer ID field too instead of customer ID. And when I select the customer from the drop down, the entire Customer ID field is getting disappeared from the Order Form .
This is what I have used but doesnt seem working.
LOOKUP( [_THISROW].[Customer] , Customers , Customer , Customer_ID )
Where am I going wrong ?