hi-
i have a table, case, that i'm to normalize.
for example, the table, case, has the following fields-
caseid = primary key
issue1 = number
issue1desc = text
issue2 = number
issue2desc = text
etc...
my form, case entry, retrieves all of the case related data. i have 3
combo boxes on this form to select an issue. these 3 combo boxes
retrieve the issues from the table, issue, and store the selection in
issuedesc instead of issueid.
the table, issue, has 2 fields, issueid and issuedescription.
for example-
issueid issuedescription
1 discrimination
2 late for work
3 sexual harassment
the combo boxes on my form, case entry, are bound to column 2, which
is issuedescription. so, the table, case, stores the selections made
in one of the issuedesc fields. this was a mistake by my predecessor.
for example-
caseid = 22
issue1 = 0
issue1desc = discrimination
issue2 = 0
issue2desc = late for work
notice how issue1 and issue2 are 0. they are 0 because the selections
made in the combo boxes on my form, case entry, are bound to column 2,
issuedescription.
how can i associate the correct issueid number with the corresponding/
matching issue description.
i've thought about append and update queries, but i'm not sure it'll
work. should i create some kind of new table and relationship and some
how use referential integrity, cascade update related records, to
match the correct issueid and description in my case table.
there are close to 300 records, and i'm dreading having to re-enter
each issue with the appropriate case record in order to make sure
issueid is bound to the combo box instead of issuedescription.
does this make sense what i'm trying to do?
thanks,
megan