A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2008, 04:13 PM posted to microsoft.public.access.tablesdbdesign
Site match by vendor and job type
external usenet poster
 
Posts: 1
Default Access

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.
  #2  
Old May 19th, 2008, 10:56 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Access

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" wrote:

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.

  #3  
Old May 20th, 2008, 03:39 PM posted to microsoft.public.access.tablesdbdesign
Site match by vendor and job type[_2_]
external usenet poster
 
Posts: 2
Default Access

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" wrote:

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" wrote:

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.

  #4  
Old May 20th, 2008, 09:03 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Access

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?




"Site match by vendor and job type" wrote:

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" wrote:

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" wrote:

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.