Default Value from tabel to table

[Guest]

Hi, I am attempting to have table1 to lookup table2 and set tabel1 Default
Values = to what Table2 say in field name MYOFFICELOCATION. Table2 will
always have one record in it. What the most easy and fast way to accomplish
this? I have an idea how to do it from a Table to a Form but not from a Table
to a Table.

Thank you,
Silvio

 

[John Vinson]

I have an idea how to do it from a Table to a Form but not from a Table
to a Table.

You can't.

Use a Form.

John W. Vinson[MVP]