New Here with a question for the Guru's

[Cbenner]

Hi Guys,

I'm fairly new to Access. But I need to find a database setup that will work with my application.

I have done some searches, as I try not to ask if I haven't searched first.

I have a business where I'm doing assemblies. They are chairs, and 40 different styles. Many of these chairs use the same parts as the other chairs.

What I need to do, is be able to load all my inventory into the database. Seats, bendings, Legs, etc.

Once the chair is built I need it to pull from the inventory those parts.

So I will need a list of the finished assemblies and when i mark one completed, it adjusts my part inventory.

I have looked through most of the templates available and some are very close to what I need.

I was wondering if anyone knows of a thread that someone has done something similar to this scenario?



Any help would be most appreciated.

Cheers and thanks in advance

[vincent-leeway]

I think you would need 3 tables with many to many relationship, first table will be chair_master with fields chair_id, type_of_chair, second table will be inventory_master with fields, inventory_id, inventory_name, quantity and then finally multi relationship table called chair_inventory with fields chair_inventory_id, chair_id(from chair_master) and inventory_id(from inventory master).

This should solve your problem, if you need further help in designing this, please do ask here.