K
klufkee
Hello all,
I have been handed a project that is no fun. They gave me a DB with 6
tables. They relate to one another but not by a common field.
Example:
Table_1 Table_2 Table_3 Table_4 Table_5 Table_6
field_1 field_3 field_4--field_2 field_5 field_1
field_2--field_2 field_5 field_3 field_4--field_2
field_3 field_1---field_1 field_4 field_3 field_3
field_4 field_4 field_2 field_5 field_2 field_4
field_5 field_5 field_3 field_1---field_1 field_5
(Sorry for the nasty graphic but I'm no good at ASCII art)
This is not an exact representation of the relationships but I'm just
trying to illustrate that field_4 in table_3 has data that matches the
values in field_2 of table_4. Also it may be helpful to note that none
of the tables have the same amount of records. e.g. table_1 has 35175
records, table_2 has 34666, table_3 has 6662 and so on.
All I want to do, (and have been trying to do for 2 weeks), is be able
to have a user search through the data. I would like to have a form
that allows them to select or enter a value from a drop down or combo
box and have the results filtered to only show the records that match
that value in that particular field. If it is helpful, I have found
that when the data from all the tables is combined (according to the
relationships), there are 22057 unique records. Of course some of the
data is duplicated when viewed this way because value 'X' in field_3 of
table_1 matches 4000 records from table_4. I would like the user to be
able to select value 'X' and have the results filtered to just those
4000 records that match. Then hopefully be able to select a value from
a different field to further filter the results.
Like I said, this is something that I have been trying to do for 2
weeks now with not much luck. I was able to create one form that would
display all the results (22057 of them) but it would not let me chose a
value from a combo box. (They would all show up in the box but when
clicking on the nothing happened.) This whole thing has me mystified. I
even bought the 'Inside Out' book from MS Press! If anyone out there
has some insight into what I'm doing wrong please let me know.
Thanks to all and sorry for the really long post.
Bill
I have been handed a project that is no fun. They gave me a DB with 6
tables. They relate to one another but not by a common field.
Example:
Table_1 Table_2 Table_3 Table_4 Table_5 Table_6
field_1 field_3 field_4--field_2 field_5 field_1
field_2--field_2 field_5 field_3 field_4--field_2
field_3 field_1---field_1 field_4 field_3 field_3
field_4 field_4 field_2 field_5 field_2 field_4
field_5 field_5 field_3 field_1---field_1 field_5
(Sorry for the nasty graphic but I'm no good at ASCII art)
This is not an exact representation of the relationships but I'm just
trying to illustrate that field_4 in table_3 has data that matches the
values in field_2 of table_4. Also it may be helpful to note that none
of the tables have the same amount of records. e.g. table_1 has 35175
records, table_2 has 34666, table_3 has 6662 and so on.
All I want to do, (and have been trying to do for 2 weeks), is be able
to have a user search through the data. I would like to have a form
that allows them to select or enter a value from a drop down or combo
box and have the results filtered to only show the records that match
that value in that particular field. If it is helpful, I have found
that when the data from all the tables is combined (according to the
relationships), there are 22057 unique records. Of course some of the
data is duplicated when viewed this way because value 'X' in field_3 of
table_1 matches 4000 records from table_4. I would like the user to be
able to select value 'X' and have the results filtered to just those
4000 records that match. Then hopefully be able to select a value from
a different field to further filter the results.
Like I said, this is something that I have been trying to do for 2
weeks now with not much luck. I was able to create one form that would
display all the results (22057 of them) but it would not let me chose a
value from a combo box. (They would all show up in the box but when
clicking on the nothing happened.) This whole thing has me mystified. I
even bought the 'Inside Out' book from MS Press! If anyone out there
has some insight into what I'm doing wrong please let me know.
Thanks to all and sorry for the really long post.
Bill