Database construction. - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 5 (permalink) Old 11-19-2003, 07:17 AM Thread Starter
TWIN SPINNER
 
Josh's Avatar
 
Join Date: Aug 2001
Location: At Work
Posts: 3,208
Database construction.

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.
Situation.
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.
Chemical
Company part #
Manufacturer part #
Stocking Location
BMS #
MIL SPEC.
Other
Keyword

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?
Josh is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 11-19-2003, 07:45 AM
Time Served
 
Join Date: Jan 2002
Location: Bedford, TX
Posts: 761
You separate the data that is reusable. For example stocking location, you create a separate table for that.

Stocking location:
ID
Description
Physical address/location

Now for the chemical you have a field for the stocking location ID. That's the link you will then use in SQL.
Sami is offline  
post #3 of 5 (permalink) Old 11-19-2003, 08:13 AM
 
Join Date: Oct 2003
Posts: 49
ASP is your friend
iyaracingdotcom is offline  
 
post #4 of 5 (permalink) Old 11-19-2003, 09:01 AM
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
You can do that in Access. Doesn't sound like a hard project at all. I would get with someone who has database knowledge as it is harder for beginners to set up the table structure correctly. After the table structure is in place then the front end, i.e. an 'Access' form should not be that big of a deal.
Tiny Tim is offline  
post #5 of 5 (permalink) Old 11-19-2003, 12:50 PM
¯\(º_o)/¯
 
AbecX's Avatar
 
Join Date: Nov 2001
Location: Las Colinas
Posts: 25,373
php and mysql, you'd be done by now. If you need help setting it up that way, shot me a pm and I'll get you started, its REALLY simple.
AbecX is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome