need to relate field of data to multiple fields of same data

[peggymlb]

I set up a database to record quality assurance calls for routine maintenance
on industrial equipment about a year ago not knowing what information i
would need to research in the future. Now I know! The main field that I need
to relate EVERYTHING to is a compartment field which is a series of numbers,
letters, and "tacks". Originally, I would list several compts in one compt
text field for each record which also includes date, time, methods used, reps
names, status of performed work, work lists written, date of work list and
date closed. I have another table that lists the compartment #, name of
compt and yes/no fields to identify installed materials for each compt. I
have recently included a new table with a complete list of compartments. The
question is: How can I identify the compt from the compt field in the new
table to record in another table that has a field with several compts listed
in that one field which in turn, is related to that certain record? My visual
basic skills are terrible, is there any other way without having to completey
rebuild my datbase?

 

[Duane Hookom]

No offense but your question asking skills need a little polishing also

Find and use the Return key to create paragraphs so your single, long
paragraph doesn't scare away potential responders (especially those of us
that are easily confused).

We don't know what a compt is. Is this a computer, component,
compartment,...?

Also, it would provide enormous help if you provided your table structure
and sample data. The last thing we would need is the desired result. While
this sounds like a lot to do, consider how much time it takes for us to
read, understand, and then respond.

 

[Pat Hartman\(MVP\)]

Starting with this --- Originally, I would list several compts in one compt
text field for each record --- If your VBA skills are terrible, you're in a
fix. It would be far better to take the time to restructure the table.
Create a new table and each "compt" needs to be stored in a separate record.
If the current table is holding all the common data for the compts, it will
be fine once you remove the compt field itself. If some of the data is
different for each compt, those fields need to be moved to the compt table.

Depending on how many references you have to the compts field, you may have
a lot of work or a little work. Replace the compts field on the form with a
subform that pulls data from the new table.