Page 1 of 1

Default for foreign key of mash subform new record

Posted: Wed Apr 24, 2013 11:53 pm
by agnar
I have a customer (company) table and a customer_contact table.

Code: Select all

customer
   customer_id
   ...
customer_contact
   customer_contact_id
   cct_customer_id
   ...
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?

Re: Default for foreign key of mash subform new record

Posted: Thu Apr 25, 2013 12:54 am
by massiws
Agnar,
you have to use the hash #browse_filter#: have a look at this video http://www.youtube.com/watch?v=6d_nYErMGPI)

Hope this helps,
Max

Re: Default for foreign key of mash subform new record

Posted: Sat Apr 27, 2013 9:38 am
by agnar
Thanks.

Finally, I got the idea of how this works...

Re: Default for foreign key of mash subform new record

Posted: Mon May 27, 2013 7:44 am
by admin
.