Access

[Site match by vendor and job type]

I'm trying to build a database to match my client locations with vendor
locations by job type. What I'd like to do is import the client locations and
job type fields so that the only data entry required would be vendor name and
placing an X in the appropriate job type field.

 

[Fred]

I think that you're going to have to add more explanation regarding your data.

It sounds like you have 3 "lists" / probable tables:

Client Locations (or is this a list of Clients with their locations?)
Job Types
Vendor Locations (or is this a list of Vendors with their locations?)

I'd recommending clarifying the above, and then explaining the relationship
between them either by a description or an example.

Then I'd suggest explaining what you want to do from a user standpoint. Do
you want certain related data to be automatically displayed? Do you want to
have it fill in a blank, or give you a list to choose from to fill in a
blank? By using words like "import" you are stating a (possibly wrong)
method of doing what you want to do instead of telling us what you want to
do.

 

[Site match by vendor and job type]

Thanks Fred. It's been awhile since I've been in Access and I think I see how
I can better explain.

1. Client location is a constant
2. Job Type is a constant
3. From a user standpoint I want to add vendors relative to the client
location and select the appropriate job type (services) for that vendor

For example --- vendor provides services in 20 locations throughout the US.
I want to match the locations with the client locations, and then select, the
job type for the vendor.

Client location - Indianapolis, IN

Vendor Name - Indianapolis, IN
Providing services for: PH, PST, IT, etc.

Vendor name will be data entry. I want to select from a list of the client
location(s) as there could be many client locations that match the vendor
locations, and thus select the job type of which the vendor provides
services. However, I don't want to have to type in client location every time
I add a vendor.

I hope I'm clear on this. Thanks for your help, I've already gained some
ensight.

 

[Fred]

Well, the good news is that once you're completed the difficulat process of
explaining this, the work is 95% done. The bad news (if you will forgive me)
is that we're not there yet.

You imply that picking a client automaticall selects a service. Is that
true, and, if "yes", how so?

Is the mission of the database just as a places to make lists of clients,
vendors and services and to make it easier to fill in a client selection for
a vendor? Are you also trying to record somehting else like:

which vendors are providing what to who?

Can there also be more than one vendor providing a service to a client?

Can theere also be a case where a vendor provides more than one service to a
particular client?