Populating Tables

[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

 

[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

 

[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

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 (e-mail address removed)