A
Aad v via AccessMonster.com
Hi group,
I have created a Form/ Subform setup.
In the subform there are the 7 comboboxes (one for each sub-action)
They all using tbl_rsp_prsns as Lookup table (set as row source)
I also add a table (tbl_action_items) which contains the 7 sub-actions and
their ID.
Below the existing tables are described.
In the SQL-server diagram window I created the relationships.
The Form and sub-form will be linked by action_ID.
But now I’m not sure how to bind the tables to my Form (and the sub-form)
When a person (rsp_prsns_ID) is selected from one of the comboboxes, how can
identified which combo (action_items_ID) was used.
In other words, which sub-action belongs to the selected person?
------------------------------
tbl_action (main)
------------------------------
action_ID PK
action_date
action_description
etc …
I have created a Form/ Subform setup.
In the subform there are the 7 comboboxes (one for each sub-action)
They all using tbl_rsp_prsns as Lookup table (set as row source)
I also add a table (tbl_action_items) which contains the 7 sub-actions and
their ID.
Below the existing tables are described.
In the SQL-server diagram window I created the relationships.
The Form and sub-form will be linked by action_ID.
But now I’m not sure how to bind the tables to my Form (and the sub-form)
When a person (rsp_prsns_ID) is selected from one of the comboboxes, how can
identified which combo (action_items_ID) was used.
In other words, which sub-action belongs to the selected person?
------------------------------
tbl_action (main)
------------------------------
action_ID PK
action_date
action_description
etc …