Allowing a table field to have multiple values

[exbelgieswig]

I have several tables that are linked with one-to-many relationships (with
the attendant sub-datasheets). In one particular table I have a business
unit describe its processes and specifying either AutoID1) Manual processing
or AutoID2) Automated Processing. Some units have both manual and automated
processing. Is their anyway to list both answers (using numerals which link
to "answers" table) without creating a third field to encapsulate both? This
is somewhat of a simplification but captures the gyst of my problem.

Thanks

 

[Jeff Boyce]

One approach might be to use a pair of yes/no fields, since it sounds like
your situation could call for either, neither or both. If you had more than
just those two conditions, I'd suggest that you need a new table to handle
the one-to-many relationship between business unit and "process type" (right
now, only Auto or Manual).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pietlinden]

I have several tables that are linked with one-to-many relationships (with
the attendant sub-datasheets).  In one particular table I have a business
unit describe its processes and specifying either AutoID1) Manual processing
or AutoID2) Automated Processing.  Some units have both manual and automated
processing.  Is their anyway to list both answers (using numerals whichlink
to "answers" table) without creating a third field to encapsulate both?  This
is somewhat of a simplification but captures the gyst of my problem.

Thanks

Bad design. I would put the Processing Type into a separate table.
(BusinessUnitID, ProcessingType)

Okay, why? What if you want to find all the places that have manual
but not automated processing? What if you add more processing types
later on? If you put everything in one field, summarizing this is
going to be a hassle.