Search results

That worked!!!! lol Now, however, it doesn't show the vendor name. Do I have to make that a lookup? I want the query to show the vendor, the part number and the part number info. I'm nothing if not persistent...

Ugh What in the WORLD am I not understanding about this. I watch the video tutorial and read on here, put it together, and I still can't get anything back. lol I've attached my two very small tables that I'm starting with. I've identified a relationship between the two, and have done one...

One more question (well, a million, but I'll start here). I have job numbers in my jobs database. Part numbers in my part number database. Vendors in my vendors database - I'm trying to pull them together in that JobParts that references both. What should the information look like in there...

Thanks.... Working on that right now! I also am reading along the way... Access for Dummies... lol :p Thank you... I anticipate I'll be an expert by... well.... the year 2035!

Next Steps for Database! Good morning! I've attached a copy of my relationships, and now I'm trying to figure out how to put it all together. Do I now do a form? What I'd like to ultimately be able to do is the following: Search for a particular part number to see who we purchase from...

Makes Sense! Let me see what I can do with it.... I'll get the hang of this.... maybe not this day... but soon! Thank you.... I'll be back to let you know how it goes!

Ok - Here's what I have for relationships! :eek:

Condensed it! The more I thought about what you said, the more I realized I was complicating things too much. (at least until I'm way smarter...). So, in looking at these three tables, I'm wondering how to connect the spare part with the job it was used on? As I said, the same part could be...

Yep - I see what you mean. So, maybe I'm trying to do too much. Basically what I need is a database that I can look up a part number, find the cost and who sells it. In thinking about your suggestions, perhaps I don't need a "Customer" table at all - just a Job table that can link: Job...

Here's my Excel Spreadsheet. Before I create the tables - does this look reasonable?

Thank you! That sounds like a fabulous idea!!! I'll be back with the results! I should've come here long before this! lol (I'm also doing an online learning, so hopefully that will also help!)

No - the part will only come from one vendor, but it could be used on multiple projects. I.E. Widgit purchased from CompanyWidgit could be used on 10 different jobs.

Here are my tiny little tables thus far: Vendors: VendorID Address City State Zip Website Phone Fax Notes VendorRep VendorRepID Company (How do I put just a place holder?) Last Name first Name Email Mobile Phone Products VendorID L&W Part Number Description Vendor Part Number Cost Sales Rep...

Greetings! I'm pretty new to all of this, and bumbling along... I'm creating a database for our spare parts program. We sell complete systems, and once installed, spare parts to support the system. I have created a Vendor Database as well as a Vendor Rep Database (there are often many...