Using combo boxes to fill in other bound controls not working..

Hi There,
I have a big table that is linked to many other tables and I have created a
form out of this. I would like
to create a search control, that can be used to search all data and it's
associated fields. 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.

I look forward to hearing from someone on this!
Thanks so much for your help..


Take care,
Smriti

Smriti Dev wrote:[color=blue]
> Hi There,
> I have a big table that is linked to many other tables and I have
> created a form out of this. I would like
> to create a search control, that can be used to search all data and
> it's associated fields. 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.
>
> I look forward to hearing from someone on this!
> Thanks so much for your help..
>
>
> Take care,
> Smriti[/color]

Not sure I get what you mean....

But what about using a query to get all your fields from the related
tables and then search that??

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

Smriti Dev wrote:
[color=blue]
> 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.[/color]

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