Is it Possible

dosgimp

Registered User.
Local time
Today, 14:49
Joined
Oct 6, 2004
Messages
12
Help Me Obe'Wan

As a Scheduler I am always looking in a 3 ring binder to find out where a certian carrier will go..

is it possible to have on a form a text box, that after typing in a location will display the list of carriers that will go there?

its not just one carrrier per location i have multiple carriers that will go there.
i would need the full list to be displayed of all that will go the

example

lets say Texas

the following will service texas
RSB logisitics
Dart
Crete
Celadon
Swift
Schneider National
National Freight

how would i go about setting this up.. table wise, query, form
any suggestions would be greatful

whatever it takes this would really make my life much easier.
 
Last edited:
you could have a simple table with 3 fields:

IDNumber - Autonumber
Carrier_Name - text
Notes - memo

Once the data has been entered, then you could have a form with a text box on it, you enter "Texas", the write a query that searches the Notes field for all carriers which texas in it.

I think is about what you require, simply to set up.

If you need any help, if you give me your email address, i can email an example database for you, it would only take me 5 minutes to set up for you.

Hope this help
 
yes that would be great if you have the time to spare. Im PM'ed you my E-Mail address..

however could we try. Per State. to list all carrier that will go there?
 
Sorry M8KWR, but mushing multiple values into a single field is a bad idea. It violates first normal form and is difficult to work with. There is actually a many-to-many relationship between carriers and places which requires three tables to implement properly.

tblCarrier:
CarrierID
CarrierName
etc.

tblStates:
StateID
StateName

tblCarrierStates:
CarrierID
StateID

Download my many-to-many example db from the samples forum to see how this type of relationship is implemented.
 

Users who are viewing this thread

Back
Top Bottom