Please point me in the right direction...

[Swift_74d]

I'm trying to create a database that can track items and the materials needed to make them. I've researched bill of material type databases but I think I’ve gotten myself confused. I currently have three tables. One based on the item, one based on materials, and one using the primary keys from the first two to identify what materials are used for what items. A sample would be something along the lines of the following<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Item_Table<o></o>
ID: 1 Name: Stool<o></o>
<o></o>
Material_Table<o></o>
ID: 1 Name: Legs<o></o>
ID: 2 Name: Seat<o></o>
<o></o>
Combine_Table<o></o>
ItemID: 1 MaterialID: 1 Amt: 4<o></o>
ItemID: 1 MaterialID: 2 Amt: 1<o></o>
<o></o>
<o></o>
My problem is trying to get this all to work in a form. I'm basically trying to get a continuous form where each "section" is based on an item id and contains all the appropriate material ids within it. If I’ve been confusing I apologize, like I said in the beginning, I may have ultimately confused myself. If it appears I’m going in the wrong direction with this project please point me in the right direction.<o></o>

 

[CharlesChuckieCharles]

is the form there to ADD new products and their components or is it just to display the components of a product??

 

[Swift_74d]

A little of both, ultimatly i want to have check boxes at the top of the form for different materials and item types to only display items that meet all checked criteria. If need be i'd like to be able to add new items and edit existing items.

 

[Swift_74d]

Actually, after fiddling with it more, i think i could solve a majority of my problems if i could find a way to force a continuous form to group on the item name (or better yet allow subforms in continuous forms)....

Instead of:

Stool / Legs / 4
Stool / Seat / 1
Table / Legs / 4
Table / TTop / 1

It would do something like:

Stool
Legs / 4
Seat / 1

Table
Legs / 4
TTop / 1

I hope thats actually easier to understand, and assist with..