Help with Spare Parts Database - I'm New!

[sbrown914]

Thanks.... Working on that right now!

I also am reading along the way... Access for Dummies... lol

Thank you... I anticipate I'll be an expert by... well.... the year 2035!

 

[theDBguy]

I bet it'll be sooner than that. Cheers!

 

[sbrown914]

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? Do I do a lookup on the VendorID? I'm not sure...

 

[plog]

You build a query with every table you need data from, as well as any that are between them in your relationship. JOIN them via the way you have in your relationships and bring down all fields you want in the query.

 

[sbrown914]

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 query to pull every part number. Nothing shows up.

What am I missing? :banghead:

Thank you....

 

[mike60smart]

Hi

Try changing the Join Type to Option 2

 

[sbrown914]

Hi

Try changing the Join Type to Option 2

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...

 

[mike60smart]

Hi

Can you upload a zipped copy of the Db??