Search-Edit record-Page-Subform

M

MN

Hello,
I have 4 table:
Table1:CaseID(PK),Lname,Fname
Table2:TBL2(PK), CaseID(FK), Status
Table3: TBL3(PK),CaseID(FK), Employername
Table4:TBL4(PK), CaseID(FK), Deptname

Link: Table1 have caseID link 1 to Many to caseID in Table2, Table3,Table4

How can I design a Search Form to search an CaseID in the SearchForm, then
open in Edit Form to edit record. On the hearder form have CaseID,
TBL2,TBL3,TBL4 let the user see but can not edit.
The Edit record Form have 4 page: Page1-to edit record Table1,
Page2 -to edit record Table2
Page3 -to edit record Table3
Page4 -to edit record Table4
After they edit they can click Save or Cancel buttons to cancel or accept to
save the records.
Any suggestion are thank you inadvange.
MN
 

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

Similar Threads

Appending question 6
Joins? 1
Query and Form to edit record 0
Problem adding record with with multi-table form 2
Open form from record in list using Allen Browne's search form 7
Multiple child-record search form? 0
Find record based on PK in Subform 1
ADP Data Entry Interface 0

Top