Auto filling a field in a table. Help please

[tdanko128]

Hello,

I'm trying to create a way to auto fill a field in a table when something one record is selected in a lookup. If it is possible.
I'm new to access but will try to describe the scenario to the best of my ability. The reason why I am trying to do this is to create a friendlier user interface for the people that will be using this database.

here is the layout.
Table One (customers)
Table Two (contracts)

In Table Two (contracts) I have set up the relationship and the proper lookup wizard to look up my customers from Table One (customers).

Our customers are mostly a contact person from a group or organization.



I would like Table Two (contracts) to automatically retrieve the information from [customers].[group name] (Table one (customers) group name field)

What i tried to do was create an update query to do this but what it did was changed all the group names to the same group name for all contract records.

[tdanko128]

Thanks Any Way

[ajetrumpet]

Thanks Any Way

marked as solved. please don't post problems that are solved in a few seconds, if you can help it. it wastes space, and other peoples' time sometimes. thanks.