i would like to have 2 or more selctions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello i am setting up a inspection process thru access to have this form on
inspections. i have the form made out kinda and am looking to improve on it.
i have about 10 or so questions in this form with a drop down box for the
answers. which are on another table in the database that are linked to the
box, from there the selection goes into a table for record keeping. I am
wondering if there is any possible way to get more then one selection to go
into the same feild of the record for example(tanks inpsections:one being
paint failure another being cracking of foundation) i would like both of
these to go to the same feild. If there is any expression i need or tool i
need to use please contact me i really need to know this?
 
Fredo,
Never place 2 values in one field.
If a tank can have more than one problem, you should establish a "one to
many" realtionship between the tank and the problems.
The "one" table would contain your tank information, and the "many" table
would contain problems associated with each tank. Those table would be
related by some unique tank value such as TankID, or TankNo... or whatever
hth
Al Camp

PS: A polite request...
When you post a question please try to use some caps, reasonable
punctuation, and paragraphing. It's very hard to read and understand a
"run-on" dialog.
This is not an English class, for sure, but it does make helping you
easier, if not more pleasant.
Thanks...
 
Back
Top