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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|