Combo Box

[Guest]

I Have a combo box on a form that when selected it ads data from one table to
another table. What I need is when this selection is made it also links more
information from one table to the other table.

 

[Guest]

Just Adding some more information to my question.

The table I am selecting from the combo box is called (siteEquip) and Using
field Name "Equipment Number" other Fields I need to link are "Location" &
"Area Serves" & "Maufacture"

When I select "Equipment Number" need to insurt information into the other
table called (MaintEquip) and the fiels are "Location " & "AreaServing" &
"Make"

 

[John Vinson]

Just Adding some more information to my question.

The table I am selecting from the combo box is called (siteEquip) and Using
field Name "Equipment Number" other Fields I need to link are "Location" &
"Area Serves" & "Maufacture"

When I select "Equipment Number" need to insurt information into the other
table called (MaintEquip) and the fiels are "Location " & "AreaServing" &
"Make"

Why?

Storing this data redundantly in a second table wastes space; far more
importantly, it risks data validity. Suppose you have a record in
SiteEquip with a Location value that's wrong; you edit the table and
correct the erroneous location.

Now you have a whole lot of records in MaintEquip *WITH THE OLD
LOCATION*. It's wrong. And there's no easy way to detect that these
records all have an incorrect location!

I'm almost certain that your MaintEquip table should NOT contain these
fields. They can readily be obtained by creating a Query joining
MaintEquip to siteEquip.

If I'm misunderstanding, please post back... but I'd say you do NOT
want to do this.

John W. Vinson[MVP]

 

[Guest]

Hi John, thanks for your help. What we are trying to do is this.

We have customers with difrent sites. In each site we have equipment where
we input the data on a form. Now we can veiw what equipment is on what site.
We have another area (page) where we can maintain some or all of the
equipment selecting the combo box show the equipment on that site and we just
keep selecting equipment to ad them. When we do this selection we want to
display this information on this form and then include this information in a
report showing this is the equipment we maintain. So yes you are correct we
need to link site equipment ID with Main Equip ID and not double up on data.
How do we get it to automaticl fill out the information on a form and how do
we display this information in a report.
--
Thanks

Craig

 

[John Vinson]

Hi John, thanks for your help. What we are trying to do is this.

We have customers with difrent sites. In each site we have equipment where
we input the data on a form. Now we can veiw what equipment is on what site.
We have another area (page) where we can maintain some or all of the
equipment selecting the combo box show the equipment on that site and we just
keep selecting equipment to ad them. When we do this selection we want to
display this information on this form and then include this information in a
report showing this is the equipment we maintain. So yes you are correct we
need to link site equipment ID with Main Equip ID and not double up on data.
How do we get it to automaticl fill out the information on a form and how do
we display this information in a report.

Use a Combo Box on the Form, bound to the equipment ID but displaying
the other field; base your Report on a Query joining the two tables.


John W. Vinson[MVP]