display data in form and subforms

[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


--
sb
Was this post helpful to you?


sb