Yes you certainly can. A Ref column is merely a reference to a row in another table. You can then access any other data on that row through “dot” notation like this
[Ref Column].[Desired Column]. Note the names in the square brackets are made up names for illustrative purposes. You would replace them with names used in your app.
Here is an example. Lets say I have an Order Table and a Customer Table. My customer table may have these columns:
In my Order Table I want to be able to chose the Customer from a dropdown but I also want to show the address as the “Job Address” and the phone as the “Job Phone”, so my Order table would include (among other columns) these 3:
I define Customer as a Ref column to the Customer Table, Job Address as Address and Job Phone as Phone.
Now, when I chose the Customer I want to copy over the address and phone into my Order. I would update each of these columns “Initial Value” properties like so:
Job Address Initial Value =
Job Phone Initial Value =
Now when I create a new Order and choose a Customer, the Job Address and Job Phone valuse will automatically be updated with the current Address and Phone from the customer record.
I hope this all makes sense!!! Good luck!!