Hi all, the question is very simple, Im pretty sure this has already been discussed but I cannot find it when searching for an answer.
I have a Properties tab with a column name Property_Name
I have a Customers tab with a column name Customer_Id
I want to create an entry to a tab called Contracts which has columns for Property_Name, Customer_ID (referece keys to the Properties and Customer tabs) and a bunch of other fields related to the contract, like start & end date, price, etc…
I need to bound the values to choose from those exisiting in Properties and Customers tabs respectively.
In other words, I can only create Contract records with existing Properties and Customers…
Thank you all in advance!!