Access Database Help.

  • Thread starter Thread starter Paul Evans
  • Start date Start date
P

Paul Evans

Help: I have a small database with three tables. One
equipment table and two lookup tables. What I want to do
is when I add a new record to the Equipment table I want
to be able to look up my department table (Ok that I have
done easy)But what I really need to do is pass additional
values which are stored in my department table over to my
equipment table automatically depending upon which
department name I pick.(The field names are the same in
each table an there exists a 1-many relationship between
the tables)
Please cany anybody help.
 
when you say you want to pass values from your department table to you
equipment table you don't mean that you are going to re-enter that inf
in the equipment table? The easiest way to do this would be through
form. You wouldn't want to have duplicated fields in multiple table
though. Just one common field for a link between the tables is enoug
and it will make coding the form easier

avalon_to
 
Back
Top