Default for foreign key of mash subform new record
Posted: Wed Apr 24, 2013 11:53 pm
I have a customer (company) table and a customer_contact table.
For the customer edit screen I have a mash subform of all contacts of that customer.
When I click [Add record] on the customer_contact subform, I want the value of the cct_customer_id to be preassigned (and preferably read-only) with the value of the current customer_id.
How do I do that?
Code: Select all
customer
customer_id
...
customer_contact
customer_contact_id
cct_customer_id
...
When I click [Add record] on the customer_contact subform, I want the value of the cct_customer_id to be preassigned (and preferably read-only) with the value of the current customer_id.
How do I do that?