Ask Your Question

how to: Form control shows a related field value but actually store the original field value? [closed]

asked 2012-11-09 00:29:45 +0200

Jesús Gómez gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 22:57:41.357552

1 Answer

Sort by » oldest newest most voted

answered 2012-11-09 15:20:06 +0200

JohnSUN gravatar image

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 Link data in form and subform

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 columnSQL-instruction as datasource

See examples at this file - DemoOfRefControl.odb

edit flag offensive delete link more

Question Tools


Asked: 2012-11-09 00:29:45 +0200

Seen: 449 times

Last updated: Nov 09 '12