Row source for table data entry

[Impecunious]

I've got a group of users that needs to directly enter some data into a
table instead of with a form. The first four columns in this child
table represent the foregin key of a parent table, and they're as such:

WS_NUMBER
SALESMAN_CODE
YEAR
TYPE

When the user enters the WS_NUMBER in this child table and tabs to,
say, the SALESMAN_CODE, I'd like this column to behave like a combo box
with a row source corresponding to the code found in the parent table,
based on the WS_NUMBER just entered. In other words, because the user
is keying in the foregin key details in this child table, I'm trying to
put some validation behind these first four columns based on the data
in the parent table.

I'm struggling to create this with the Lookup properties in the Table
Design view, and I'm not sure if setting the relationships between
these tables would do the trick. Can somebody point me in the right
direction? A big thanks in advance.

 

[Graham Mandeno]

But WHY???????

This is what forms are for... data entry. Tables are not designed for data
entry and should not be used for that purpose.

You can easily create a simple form bound to your table, and even make it
*look* just like the table. Then you can make use of all the features of
forms such as advanced controls and events to control and verify the data
entry.

 

[John Vinson]

I've got a group of users that needs to directly enter some data into a
table instead of with a form.

Ummm... No. They don't.

You can create a Datasheet Form, or (better) a COntinuous Form, which
has combo boxes, events, validation, etc.; it can LOOK very much like
a table, if that's what they want. But as Graham says, tables are for
data *storage*, not for data entry.

John W. Vinson[MVP]