display data in form and subforms

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


--
sb
Was this post helpful to you?


sb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top