How to: Form control shows a related field value but actually store the original field value?

[JesúsGómez]

I Have a registered Data Base with two tables: Original and Referenced. Original has a Ref Integer Field. Referenced has an ID Integer primary key and a Repr text field. The idea is that the records from Original store in the Ref field a number corresponding to the ID value of some record in the Referenced table.

Now, i have a Writer doc with a form. I wold like a Form control (maybe a List control) which displays all the values in the Repr field in the Referenced table so the user select one making the form to store a new Original record with the corresponding Ref Number.

How can i do this?

[JohnSUN]

You can choose from several ways.

Variant 1. Form with subform. In the main form place a table with the data from Original. In subform place table with the values ​​of Referenced

Variant 2. Create a form with a table for the data from Referenced. Change type of column Ref to List. Set SQL-instruction in property of this column

See examples at this file - DemoOfRefControl.odb