auto update columns in a form

[Guest]

In my main form, I want a subform that when I type an employees name, it
automatically inserts the title and shift. Two tables involved, the Employee
table has all the information. the Employees involved table should update
with the entries in the subform. Please help

 

[Guest]

You will need to set up a relationship between the tables - this could be the
employeeID.

Create a one-to-many relationship if employees can have more than one shift
patten.

If you're not to sure how to set the child/master critirea than a good idea
would be to use the new form wizard. Click the main table (sinlge click so
as not to open it)and click new object (it's at the top of the screen).

Select form wizard and then follow the on screen tips and you will be able
to create the form and sub form you're after.

A good idea would also be to look at the new form in design view and then
properties box to see how it is linked.

Hope this helps

 

[Guest]

Thanks Wayne, do you know where I could find an example form that would do
what I'm trying?