MS Access help!!! linking two tables?

Question

I have two tables in microsoft access. I have a "prospect" table that has various columns we'll call them (a,b,c,d,e,f). the "prospect" table already has b,c,d already filled in and I have another table called my "officer" table. I want column a to be the shared field between the two tables so that when I input data into column a on "prospect" table, access will know to fill in fields e,f accordingly with data from the "officer" table. thanks!!

Answer 1

Sounds like Your used to using EXCEL.

While You CAN enter data directly to the tables, it's MUCH more flexible in ACCESS if You use FORMS.



In order to do THIS sort of thing in ACCESS You NEED to do your data entry through a FORM.



The Form will be "driven" by (or based on) the "Prospect" table, You'll have to experiment with a COMBO-BOX as a lookup for the fields from "OFFICER" that You want filled in.



Check out the Microsoft Knowledge base. It's free and has LOTS of extra helpfiles/sample code/etc... Also You could download the sample DB "NORTHWIND". It has walk-throughs on how to set up stuff just like this.

Answer 2

Access cannot do this. You would have to input the data yourself unless you write some code that will complete this for you.



You could do a Append query to append all the information from one table to another. But for what your wanting to do this sounds more like some code writting to get it to do exactly what you want it too.

Answer 3

Your two computers would have t be on the same network. On the second computer create a new table but select "Link Table". Then the updates on both computers will go into the same database.