Filtering records

[Fireflycph]

Hi,

I, a newbee, have a probably easy question.

I have a table containing data pertaining to cars and their mechanic visits.
What I want to do is to create a form and use the mechanics name and the
facilitys name in Dropdown boxes as filters. Only problem is that the
mechanics and facilities appear thousands of times in that table.

How do I eliminate duplicates? I tried to create tables with unique records
for mechanics and facilities but then I can not filter on the form when
those tables are set as the source for my dropdown oxes.

Hope I explained it sufficiently and didn't confuse anyone. I'll appriciate
any guidance,

 

[John Vinson]

Hi,

I, a newbee, have a probably easy question.

I have a table containing data pertaining to cars and their mechanic visits.
What I want to do is to create a form and use the mechanics name and the
facilitys name in Dropdown boxes as filters. Only problem is that the
mechanics and facilities appear thousands of times in that table.

How do I eliminate duplicates? I tried to create tables with unique records
for mechanics and facilities but then I can not filter on the form when
those tables are set as the source for my dropdown oxes.

Hope I explained it sufficiently and didn't confuse anyone. I'll appriciate
any guidance,

What tables do you have in your database?

You should almost certainly have a table of Mechanics, and a table of
Facilities, with one record per mechanic (or per facility). It sounds
like you don't.

You can create such a table from your existing table using a MakeTable
Query; set the query's Properties so that the Unique Values property
is true. Without knowing more about the structure of your table,
though, I can't be sure how best to do this.

John W. Vinson[MVP]

 

[Fireflycph]

What tables do you have in your database?

You should almost certainly have a table of Mechanics, and a table of
Facilities, with one record per mechanic (or per facility). It sounds
like you don't.

You can create such a table from your existing table using a MakeTable
Query; set the query's Properties so that the Unique Values property
is true. Without knowing more about the structure of your table,
though, I can't be sure how best to do this.

John W. Vinson[MVP]

Hi John,

Thanks for your reply.

I have 3 tables. One with Facilities, one with mechanics both of which have
been extracted using the method you described above. Finally one with all
the records of every mechanic/facility encounter. This table contains other
fields I need to see on my form/report.

I then created One-Many relationships between the unique
facilities/mechanics tables and the corresponding fields in the "raw data"
table.

What I now want to do is to create a form where I can use 2 dropdown boxes,
one for mechanics and one for facilites both and have the records contained
in the "raw data" table filtered based on my selections. The dropdown boxes
get their data from the mechanics and facilities tables respectively.

Again, I hope I didn't make it to confusing.