I have a frmMaster, frmDetail and fromDetailChild. I created form with subform concept i.e. Master-->Detail-->DetailChild.
Q1. Is necessary to add primary key a table to b and then b table's primary key to c. If i do that it showes same field on three different locations in the form
Q2. For example if I show that fields, how do I hide them . i used .visible=false. It is not working.
Q3. If I don't add primary key fields in sub forms, it works fine with Master-->Detail but when it tries to save in Detail-->DetailChild, it raises error that primary key can't be null.