Importing records with CheckBox value lists

[Jarvis]

I am building a database for managing activities in my cabinet shop.

The database has two tables with similar fields.

 

 

(Table 1) contains the fields:  POSSIBLE TASK  & QUALIFIED WORKER

 

(Table 2) contains the fields:  TASK DESCRIPTION & ASSIGNED WORKER

 

(Table 1) is essentially like a grocery store.  It contains all the possible ingredients (POSSIBLE TASK) to build any kitchen we might sell and all the possible vendors for the task (QUALIFIED WORKER).

 

(Table 2) records are created on a cabinet by cabinet basis.

Each time we sell a particular type of cabinet the tasks germane to that cabinet are imported from Table 1.

 

 

The field QUALIFIED WORKER is managed by the shop foreman.  

He evaluates the various workers and decides if they are sufficiently trained to perform certain tasks.

QUALIFIED WORKER is populated from a value list with a checkbox interface.

 

 

When I import the records right now everything shows up fine except that all the "checked" selections disappear.

Is there a way to import records from Table 1 into Table 2 in a way that keeps the integrity of of the checked boxes intact?

.

 

 

 

 

[Ocean West]

I would recommend using an attribute table for the skilled tasks making it a join table and use a portal to create the records just as you would tick a check box - it is much more versatile and allows for fixing typos in a checkbox value list. 

 

here is a basic concept.

tasks.fp7.zip

[Jarvis]

Thanks Stephen!

Comment also suggested that I use a join table for a similar project.

I guess I am going to have to dig in and learn more about that.