Multiple table through record set

[sukhjinder]

Sir,
I have a database for the personal of peoples which is organised to maintain the information in table. These table are as follows
Basic info like First name, Last name gender, spouse, childs,country state
Medical info like age, height, weight,any disease, etc
Cards like Driving, insurance, etc
Address like present, permanent, Home, Spouse address
Education like qualification. institute, marks , grade , etc
Job like organisation, employee number, etc

How i will enter all these records into one form through record set.

[CJ_London]

you use subforms - I would expect the main form would have your basic info table and each of the other tables would be in subforms (the join being represented by the subform control linkchild and linkmaster properties) on that main form

The rule is one table, one form. Do not try to link your tables together into one big query for a single form - you will not be able to edit the data

[sukhjinder]

Thanks a lot for replying i will work on Your rule ie one table one form . I will form and come back if i face the problem

[sukhjinder]

i have made all the sub forms and attached it to main from
is it possible to add update and delete the record on the main form simultaneously

[CJ_London]

is it possible to add update and delete the record on the main form simultaneously

I don't understand what you mean