Populating Tables

H

Hanksor

I hope this makes sense. I have three tables (X, Y, Z). The info in table
X is input from a form. I would like to be able to automatically populate Y
and Z with the ID from X. Is there a way to do this without manually
populating Y and Z. Any help will be appreciated.

hanksor
 
R

Rick B

Build a one-to-one relationship for each table.

Create a query to pull all three.

Base your form on that query.

I think that will do it. You may need to include the ID field from table Y
and table Z on your form as well. Then add code to enter the value in the
two fields from the X ID field.

Hope that helps,

Rick B


I hope this makes sense. I have three tables (X, Y, Z). The info in table
X is input from a form. I would like to be able to automatically populate Y
and Z with the ID from X. Is there a way to do this without manually
populating Y and Z. Any help will be appreciated.

hanksor
 
G

Guest

-----Original Message-----
I hope this makes sense. I have three tables (X, Y, Z). The info in table
X is input from a form. I would like to be able to automatically populate Y
and Z with the ID from X. Is there a way to do this without manually
populating Y and Z. Any help will be appreciated.

hanksor

Hanksor
.I think I understand your question. Can you make table
Click to expand...
X a lookup table and when you choose on the value of x it
will pull the information into another table. If you
need further help, and it sounds as if this is what you
are trying to do, you can email me at [email protected]
 
Top