Default value can be another fields data in same record.

  • Thread starter Thread starter mtk22002
  • Start date Start date
M

mtk22002

For some reasons I have to create 3 tables with one common

field(contact_id) that would be unique and PrimaryKey in all

3 tables. The value of this field should be same in each

table for each corresponding record. It can be auto number

or long integer data type. The data entry is to be done by

Forms and the form will contain fields from all the 3

tables. Now I want the Field <Contact_id> to take the same

value in all 3 tables when I am feeding data in the form.
Please advice me how I can do that.

Is there any way by which I can define a default value to be

same as the value that has been fed in a field of form for

same record.
 
The easiest way would be to designate one table the "main table" and make
that contact id be generated by auto number. The other two would have long
integer as field type. Only put fields from the main table on the form and
then use a subform for each of the other two tables. When the subform is
linked to the main form on contact id, it will automatically populate those
fields with the number generated by the main table.
 
Back
Top