Multitable forms

[rosh]

Hi,

I need to create a single form for insurance db(Access 2003)with customer info and insurance policy info. I have both customer(primary key=customer id)and policy table (primary key=policy id)in the db.

Can somebody please help me in creating the form as one customer can have multiple policies like home, auto etc


Looking forward to reply

Thanks
---Rosh

 

[Dezirous]

Hi Rosh,
It is possible, just insert new field "customer id" in policy table and set its datatype "Number". OK, now create a form using CUSTOMER table/query then create a form using POLICY table/query. Now in your CUSTOMER form, insert POLICY form as subform and from its properties, set Link Child Field and Link Master Field as "CUSTOMERID". Thats it. Hope it will work...