Smriti Dev wrote:
The problem I'm having is that the data is split into
other tables and I am not able to get the tables to display with the valid
fields when I do a search under a certain category.
Whoa, on first reading this does not sound good. Are you saying the
exact same type of information is split amongst several tables? If so,
this is not good database practice. Some folks tend to want to split
their tables up based on the wrong kinds of information. A common sort
of example would be to have data on items or transactions split into
tables by year or by faculty/department, eg, fixed assets at a
university arranged such that there is a separate table for FA for the
science faculty, engineering and so on. Hopefully, your data is not
arranged like this.
--
Tim
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me