Anyone no how to do this? First attempt at constructing a database. I have no formal training and am having quite a time as you might imagine. What I am attempting seems as though it should not be as difficult as it has turned out.
I work in a newly formed shop at my place of employment, that is tasked with the logistics of several hundred chemicals. Simply put I issues and place orders for chemicals. The problem which I wish to streamline is this; with so many chemicals, all of which have more than 1 designation (MIL SPECS., Manufacturers #, my company's number, etc...), how can I create a database which will cross-reference all the designations.
I have eight fields that I require.
Company part #
Manufacturer part #
For instance, someone approaches me in need of a certain chemical of which I am unfamiliar. I would like to enter the information given me into a field, push enter and have all the cross referenced information pop up. Example, Joe Schmoe knocks on my window in need of MIL-3-33. Problem is we do not stock our chemicals by MIL SPEC. So I need to enter MIL-3-33 in the "MIL SPEC" field and have the COMPANY PART # and STOCKING LOCATION pop up.
I am using MS Access.
Any ideas? Is this more complex than I probably think?