D
DavidHawes
Dear all,
I've designed a database with two primary tables:
1) deactivation_requests
2) action_plans
I have designed forms for both of these to allow for simple data entry.
All is well and good so far.
There are 2 fields within each table ('trust_name' and 'request_id') that
link the two tables together.
When data is entered into the deactivation_request form, sometimes (but not
all) the user will need to enter data into the action_plan form for that
request_id. I would like to have a button (or possibly a sub-form, depending
on which is best) that would open the action_plan form and auto populate the
request_id and trust_id fields and allow me to enter the appropriate action
plan info for that request.
When I tried setting up a sub-form, the request_id and trust_name fields
autopopulated. I do not want this, since not all requests will have action
plan information associated with them.
Would it be possible to create the action_plan form seperately and have the
two linked fields autopopulate only when I open this form using a button
embedded into the 'deactivation_request' form??
e.g. something like the me.deactivation_request.request_id code <-- i know
that's not totally correct but i know it's something like that - i've used
similar code in other databases before.
Any help with this would be greatly appreciated.
David
I've designed a database with two primary tables:
1) deactivation_requests
2) action_plans
I have designed forms for both of these to allow for simple data entry.
All is well and good so far.
There are 2 fields within each table ('trust_name' and 'request_id') that
link the two tables together.
When data is entered into the deactivation_request form, sometimes (but not
all) the user will need to enter data into the action_plan form for that
request_id. I would like to have a button (or possibly a sub-form, depending
on which is best) that would open the action_plan form and auto populate the
request_id and trust_id fields and allow me to enter the appropriate action
plan info for that request.
When I tried setting up a sub-form, the request_id and trust_name fields
autopopulated. I do not want this, since not all requests will have action
plan information associated with them.
Would it be possible to create the action_plan form seperately and have the
two linked fields autopopulate only when I open this form using a button
embedded into the 'deactivation_request' form??
e.g. something like the me.deactivation_request.request_id code <-- i know
that's not totally correct but i know it's something like that - i've used
similar code in other databases before.
Any help with this would be greatly appreciated.
David