O
obzerbin
Good Afternoon...
I have a continuous form that lists projects. In each project, there
is a list box containing a list of tasks for that project. The tasks
are different from project to project. The tasks are stored in a
separate table than the projects, but the tasks all reference the
respective key for the project to which they have been designated.
This seems like it should work just fine. Populate the rowsource with
the select query to the task table and ensure that the project key in
it coincides with the bound column in the list box. Then set the list
box control source to the project key in the continuous form and it
should sync up. I have done this before with combo boxes with a 'one
to one', but not a list box with a 'one to many'.
Am I spit-ballin here?
Any advice appreciated...
Regards,
Hans
I have a continuous form that lists projects. In each project, there
is a list box containing a list of tasks for that project. The tasks
are different from project to project. The tasks are stored in a
separate table than the projects, but the tasks all reference the
respective key for the project to which they have been designated.
This seems like it should work just fine. Populate the rowsource with
the select query to the task table and ensure that the project key in
it coincides with the bound column in the list box. Then set the list
box control source to the project key in the continuous form and it
should sync up. I have done this before with combo boxes with a 'one
to one', but not a list box with a 'one to many'.
Am I spit-ballin here?
Any advice appreciated...
Regards,
Hans