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.