How can I make a sub form for inserting a data into a table in for

G

ghost

Hi,
I have a form for viewing a data for specific employee. What I want to do is
adding a subform for inserting e.g. No. of task to the employee.
Clarification
Employee table
ID#(PK)
name
completed tasks
Supervisor Name
Table of tasks.
 Employee ID#(PK)
 Task per month
 Month
 Year

thx
 
W

Wayne-I-M

Hi

Design your 2nd form and then save it. Open your main form in design view
and select Subform icon from the toolbox and click somewhere on your main
form. The wizarsd will ask you to link fields (to tie the 2 forms together).
In this case I would select EmployeeID#(PK) which should be include on both
forms. If this is not on the drop down list then go back to the 1st form
design and include it then repete these actions.

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top