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 sales folks for each company). I've started a Project Database (we do large jobs, so this is quite manageable), and am working on the Product Database.
My question is - Each Product may be used on several jobs. How do I create a relationship that provides the opportunity to pull up a product and see each project it was used on? I'd like this to be a query so that when I do a search for a product number it will pull up each project it was utilized on.
Thank you!
Sandi
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 sales folks for each company). I've started a Project Database (we do large jobs, so this is quite manageable), and am working on the Product Database.
My question is - Each Product may be used on several jobs. How do I create a relationship that provides the opportunity to pull up a product and see each project it was used on? I'd like this to be a query so that when I do a search for a product number it will pull up each project it was utilized on.
Thank you!
Sandi