Can default value be data from another field of same record.

[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.

 

[Al Camp]

mtk,
You don't have to "enter" the Key field value in the other two tables
manually.
If you set up a realtionship between tbl1 and tbl2 and tbl3, via the Key
field from tbl1, any records you enter into 2 and 3 will be assigned the Key
value from tbl1 automatically.

Let's say you have a tblCustomers and a secondary tblPurchases, linked
via a realtionship through a key field CustomerID. You set up a form with
Customers in the main form, and Purchases in a subform, linked via
CustomerID. Then... any purchases you enter in the Purchases subform will
have the CustomerID from that associated Customer record automatically
entered on each purchase record.
That's what relationships do...