Getting and Saving data From Multiple Tables

[cnuhima]

Hi guys,

I need to use 2 tables in a single form with out using subform and the another form option.

i having 2 tables which stores the personal data and Dependents data..

Now I want to create a Client information form which actually stores and retrieves data from both personal and dependents..

Please help me out..

With Regards,
HimaBindu.B

 

[Rabbie]

If it is a One to Many relationship between personal and dependents then the best solution is a form/subform.

You will need to build a query which collects the data from personal and dependents and base your form on that.