Repetition

[ben.hornshaw]

Hi all

I have a table called Vendors and another called Trucking. i have set up a 1 to many relationship between these because one vendor may use many trucking companies.

i want to create a drop down combo box that displays all the currrently used trucking companies so i can select one easily. To do this I created a query that filters the trucking companies down to only the ones that are used but i get the following:

Millar
Millar
Fly by night
fly by night
Stage Truck
Stage Truck
Stage Truck etc

Can i stop the repetition some how so all that lists is
Millar
Fly By Night
Stage Truck

thanks

 

[SOS]

Click the Grouping/Totals button (looks like Greek Sigma)

 

[ben.hornshaw]

i assume you want me to use the group by function but how??

the field i am doing this against is a text field?

i now have a Total Row and under each field is Group by what next?

 

[SOS]

i assume you want me to use the group by function but how??

the field i am doing this against is a text field?

i now have a Total Row and under each field is Group by what next?

Your combo box's ROW SOURCE should be a QUERY not a table. You can do exactly what I said in a query.

 

[ben.hornshaw]

im sorry i still dont understand

i have attached a help database that i have just made to illustrate the problem. im sure its me but i already have a query but it displays the sametransport company over and over again

any more help would be greatly appreciated

 

[SOS]

See revised attached.

 

[ben.hornshaw]

Thats Great thanks

 

[SOS]

No problem - did you see how using the Grouping changed what you had?

 

[ben.hornshaw]

yea great

i had used the grouping in the wrong query

Thanks