By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,914 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,914 IT Pros & Developers. It's quick & easy.

Help in Linking Fields

P: n/a

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

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,

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?


Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.