Append with criteria exceptions

[Jody]

I am working on an existing database that was heavily "managed" for the end
users and I am trying to lean up the process and put some things in the
users' hands. One of the tasks is allowing the end user to add fields to a
set of related combo boxes. I will try to lay out what I am trying to say:

Tables/columns to append to:
Issue1_tbl: Issue1
Issue2_tbl: Issue1, Issue2
Issue3_tbl: Issue2, Issue3
Issue4_tbl: Issue3, Issue4

There are combo boxes are based on select statements that determine the
content of the box based on the previous box (from content within these
tables). Simply, what you see in combo box two is determined by the
selection you made in combo box one and so forth.

My dilemma is that I need to develop a form that would be possibly linked to
an IssueMaster_tbl that would allow the end user to either select existing
data, or enter new criteria into any one of the fields and then "post"
(append) this data across the four base tables, taking care not to duplicate
any entries.

To maybe explain further here is a sample of the table content:

Issue1_tbl
Non Conformance
Broken Piece

Issue2_tbl
Non Conformance | Wrong Color
Non Conformance | Too heavy
Non Conformance | Too Light
Broken Piece | Top
Broken Piece | Bottom
Broken Piece | Side

Issue3_tbl
Wrong Color | Red
Wrong Color | Blue
Wrong Color | Green
Top | Lid
Top | Handle
Top | Rim


....I think you can get the point... Is there a way to achieve my desired
result of dynamically appending data across tables without duplicating
entries?

 

[Guest]

I am working on an existing database that was heavily "managed" for the
end
users and I am trying to lean up the process and put some things in the
users' hands. One of the tasks is allowing the end user to add fields to
a
set of related combo boxes. I will try to lay out what I am trying to
say:

Tables/columns to append to:
Issue1_tbl: Issue1
Issue2_tbl: Issue1, Issue2
Issue3_tbl: Issue2, Issue3
Issue4_tbl: Issue3, Issue4

There are combo boxes are based on select statements that determine the
content of the box based on the previous box (from content within these
tables). Simply, what you see in combo box two is determined by the
selection you made in combo box one and so forth.

My dilemma is that I need to develop a form that would be possibly linked
to
an IssueMaster_tbl that would allow the end user to either select existing
data, or enter new criteria into any one of the fields and then "post"
(append) this data across the four base tables, taking care not to
duplicate
any entries.

To maybe explain further here is a sample of the table content:

Issue1_tbl
Non Conformance
Broken Piece

Issue2_tbl
Non Conformance | Wrong Color
Non Conformance | Too heavy
Non Conformance | Too Light
Broken Piece | Top
Broken Piece | Bottom
Broken Piece | Side

Issue3_tbl
Wrong Color | Red
Wrong Color | Blue
Wrong Color | Green
Top | Lid
Top | Handle
Top | Rim


...I think you can get the point... Is there a way to achieve my desired
result of dynamically appending data across tables without duplicating
entries?