Subform with CheckBox for Data entry

  • Thread starter Thread starter karlwelty
  • Start date Start date
K

karlwelty

I have a question on form design for a multi-relational table.

Let's say I have 2 tables:

Table1:
Project ID
Project Name

Table2:
Project ID
System Impacted

Now I know the list of possible systems that could be impacted in table
2, and on my form I want to give the users a checkbox for my
pre-defined list of systems.

My initial thought is that Table2 would be a subform of checkboxes for
each system I know of. If they select it, I insert the record in Table
2 for that System.

Does anyone know how to accomplish this or if this would be unwise from
a design perspective?

Thanks for comments/suggestions.
 
Karl,

There are several approaches to choose from.

One is to use a multi-select listbox with all the systems on the form,
along with a command button which runs some VBA code to create the
records through a recordset operation.

Another is to use a third table with to hold all the systems, with a
field for system (ID) and a yes/no field (for selection on the form),
and two queries, (a) an Update one to clear all the checks from table3
for a new selection, and (b) an Append one to arrend records to Table2
as per the checks in Table3 (fired by a command button).

HTH,
Nikos
 
Back
Top