Turning a list in a table into multiple Yes/No Tick boxes on a For

[LGM2006]

Within my database I have a table with 3 columns containing about 60 records
(which refer to a category of business they fit into), each of which is
unique. I then have a second table with a large number of records. Each of
these records can fit into a number of the categories of business from Table
1. I want to be able to set up a Form to input new records for the second
table, but have tick boxes for each of the categories of business they match.
I.e. make each record in table 1 become a Yes/No field for table 2.

Is this possible?

 

[Ken Sheridan]

What you have here is a many-to-many relationship between Businesses (table2)
and Categories(table1). The way to model such a relationship type is with a
third table with two columns, each of which is a foreign key referencing the
primary key of the other tables, e.g. the columns might be CategoryID and
BusinessID. In this third table, BusinessCategories say, the two columns
together form its composite primary key.

For data input you'd use a form based on the Businesses table, in single
form view, with a subform in continuous form view within it based on the
BusinessCategories table. The form and subform would be linked on the
BusinessID columns and would contain a combo box bound to the CategoryID
column and drawing its rows from the categories table. Any number of
categories per business can thus be selected in the subform.

Ken Sheridan
Stafford, England