Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need suggestions concerning B.O.M table structure

Status
Not open for further replies.

Autoeng

Technical User
Jul 16, 2002
57
US
I am soliciting suggestions on what would be the best way to construct a bills of materials table. I currently have a db in place to document and control engineering changes to the products we produce. This database consists of one form which is a traditional data entry form, a subform (again traditional data entry) and another subform (this one in table format). In the table format subform the users enter everything affected by the change, (end product, sub assemblies and parts). As a change might affect many end products the users like to group the affected end products, sub assembles and parts together and then separate them from other end products by inserting a blank row.

Example: Green Widget (end product)
Green plastic widget body (sub assembly)
Raw green plastic (part)
(blank row)
Red Widget (another end product)
Red plastic Widget body (another sub assm)
Raw red plastic (another part)

I know that this can't be good for my database. If I could left indent, center, right indent, bold and italic in a table I could get them to stop the blank row insertion as they could modify format to indicate structure, however I haven't identified a method to do this inside of a form.

Does anyone have any suggestions so that I don't have all of these blank rows hogging up space, memory and resources in the table.

Thanks to all that are willing to submit suggestions,
Autoeng
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top