Hi Kirrthana,
I have created a database with four tables,i have to search and
retrieve data from all the four tables based on the entry i get
from the previous table and display all the entries,could anybody
tell how to do it.
I'm not sure what you mean. If you mean you have four tables with
similar fields, and you want to SELECT data from all of them at
once, then you can create a dynamic compound table that will
contain all the data, and SELECT from that.
Or, if you mean that the result of SELECTing in one table becomes
the basis of the SELECT in the next, that is something like the
sequence...
i have to select from four tables by matching with all these field.
By getting the search string from previous table im not only
retrieving data
from the table4,at each step i have to retrieve data from 3 tables
and store
it in the data structure.
Your two last statements still seem contradictory to me, as to what
you want to achieve. As per my first response, I don't understand
whether you want to search one corresponding field across four
databases, or search one at a time, using the result as the criteria
for the next one.
Please give us an example.
Thanks,
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------