Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Building Product Database


Recommended Posts

I am in the process of building a database for repairs, services, and products.

Working on products at the moment. Item codes are to be built out of a tree of identifiers.


(Category) / Group(any number) / Subgroup(1-8 for each group) / Metal (1-12 for each subgroup) / Size (0-10 for each metal).


At the end of it I want to have a separate table populated with records showing items, descriptions, metals and sizes.

My thoughts at the moment are to begin with a Group table, group records containing delimited text fields for subgroup codes, subgroup description, metal, and size. A looping script to build the item code and description from the text fields.

I have done something like this recently for the repair category and know that it will work, but what I would like to ask is whether there might be a better or more efficient method. The total number of records when this is completed will be less than 1000.



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use