How to add Form with SubForm & make both of them editable?

[amita]

Hi,

I have 2 tables:


1. ContactDetails - having id, address
2. Client - having id,name,resAddrId
resAddrId in Client table is foreign key for Id in ContactDetails table

Now I tried designing a form with Client & ContactDetails table using subForm but everytime Client form is coming as Subform.What might be the problem? Kindly help.

Thanks,
Amita

[pbaldy]

I would expect the ID from client to be a foreign key in the contact details table. What data do they contain, or more accurately how do they relate to each other?

[amita]

ContactDetails Table Data:
-----------------------------
Id Address LandMark City
------------------------------------------------------------------------
101 101, New Empire House Near Main Gate Delhi
102 509, My Office Adddr Near Small town Rd Mumbai

Client Data:
============
Id Name resAddrId officeAddrId
------------------------------------------------------------
301 Mr.Dsouza 101 102

& so On.....
So resAddrId of Client Table = Foreign Key for Id in ContactDetail table
& officeAddrId of Client Table = Foreign Key for Id in ContactDetail table

[pbaldy]

I would probably have something like this, adding a type field to denote what type of address each is:

ContactDetails Table Data:
-----------------------------
Id Address LandMark City ClientID AddType
------------------------------------------------------------------------
101 101, New Empire House Near Main Gate Delhi 301 R
102 509, My Office Adddr Near Small town Rd Mumbai 301 O

Client Data:
============
Id Name
------------------------------------------------------------
301 Mr.Dsouza

That let's you have more addresses if needed, like shipping, etc.

[amita]

Thanks Mr.Paul,

I implemented the design changes you suggested & it worked.

Thanks a Lot !

Regards,
Amita

[pbaldy]

Happy to help!