Access Database Help.

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.
 
A

avalon_too

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form creates unwanted rows in table 1
Left Join issues 1
VBA - retrieve data on last create named range from previous inserted named range 0
Unique Value not Showing Up, Repeating Information 1
form doesn't show what I choose in combo box 5
Form Lookup From Query - Display different from data in table 1
Error When Entering Data in a Subform 4
Restricting Access to Certain Information 3

Top