473,320 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help in Linking Fields

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
Nov 12 '05 #1
0 1210

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Phil S | last post by:
I used the Migration Workbench for Oracle 9.2 Client to migrate the tables in an Access 2K back-end database to Oracle. (The Migration Workbench is intended to automate the process of migrating...
5
by: Arvin Portlock | last post by:
I can't come up with a query that works. Can anyone help? Conceptually the relationships are easy to describe. I have a table for books (Entries), a table for authors (Authors), and a linking...
4
by: Gary Hughes | last post by:
Hi all, sometime I posted a problem in here where I was getting the following error from the linker in VS C++ 2003. Linking... GCClass.obj : error LNK2022: metadata operation failed (80131188)...
0
by: Pat Sagaser via .NET 247 | last post by:
I'm using a repeater with a dynamic template. I don't know the fields to display (or how many) until runtime. I have everything working except for linking Button events to the repeaters ItemCommand...
6
by: dick | last post by:
Am working with MS Access 2003 & tables downloaded from Oracle. Am not a GURU, more of a hacker, but have done a bit of everything in many languages/programs/etc. I have data fields in 2 tables...
0
by: Mary | last post by:
I have a main form with one subform that is used to record test scores. The main form has the following fields: WratStudentID ( a combo box with 2 fields - student id and student name - . Stores...
47
by: Jo | last post by:
Hi there, I'm Jo and it's the first time I've posted here. I'm in process of creating a database at work and have come a little unstuck.....I'm a bit of a novice and wondered if anyone could...
6
by: bmoore | last post by:
Greetings, This seems like it should be a simple problem, but I'm new to Access and my digging hasn't yielded a solution. I would like to create a table in a non-protected database that contains...
0
by: Tarik Monem | last post by:
I have been working on an all AJAX/DOM web site which is set to go live today and I thought I'd share my discoveries with all of you whom have helped me when I have encountered different issues along...
3
by: ARC | last post by:
I'm having trouble here with Access 2007 and connecting to a different database. The code below works great IF the previous back-end database connection is still present and you are trying to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.