S
sudhir
i would be very grateful for ur help.
i have a pateint database ( confirming to strigent criterias required)
table t1is the master table containg field idno wich is a unique field and
is a combobox. the table has other fields as well. form f1 is based on t1
tables t2.t3.t4 contain other details and are one - many or many to many
relationship with each other or with t1. form f2,f3,f4 are based on t2,t3,t4
respectively and have idno or some other field as a common field.
to make data reading more sensible about 4-5 fields are common to all tables.
on form f1 i have created 3 tabs- each containg a subform sf2,sf3,sf4
created by using subform control button by dragging f2,f3,f4 on to f1 tabs.
while staying in idno field in f1- i want to say to SQL engine to do-
display all the data in all fields in all subforms( though i can see only
one subform and f1 data at any one time) that are related to idno that i have
just entered.
is this possible?
if it is possible- then as i scroll the idnos in idno field in f1 will i see
the all info scroll in all fields in f2,f3,f4 ??
many thanks for the help
sb
i have a pateint database ( confirming to strigent criterias required)
table t1is the master table containg field idno wich is a unique field and
is a combobox. the table has other fields as well. form f1 is based on t1
tables t2.t3.t4 contain other details and are one - many or many to many
relationship with each other or with t1. form f2,f3,f4 are based on t2,t3,t4
respectively and have idno or some other field as a common field.
to make data reading more sensible about 4-5 fields are common to all tables.
on form f1 i have created 3 tabs- each containg a subform sf2,sf3,sf4
created by using subform control button by dragging f2,f3,f4 on to f1 tabs.
while staying in idno field in f1- i want to say to SQL engine to do-
display all the data in all fields in all subforms( though i can see only
one subform and f1 data at any one time) that are related to idno that i have
just entered.
is this possible?
if it is possible- then as i scroll the idnos in idno field in f1 will i see
the all info scroll in all fields in f2,f3,f4 ??
many thanks for the help
sb