Hi,

I am new to access. I have a project like this.

table 1 contain project no,project name,.......

table 2 contain project no, date received, date ended........


Now my problem is

1. How do i create a form for this?

2. Based on the project no selected from the table 1 i should enter the other details for table 2 and save itor even edit at times. For example my project no is A123.For this project no. upon selecting from the combobox i should enter the date received, date ended and many more fields and save it in the second table. How do i do this?

Can anybody help me pl.

thanks
puttu

Use a mainform/subform combo.