By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,523 Members | 1,938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,523 IT Pros & Developers. It's quick & easy.

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

P: n/a

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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Br
Smriti Dev wrote:
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


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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.