Creating a new database for items and quotes

[wizzard011]

Okay,

Here's what I have so far.

I have Items.

Each item can have upto 10 different part numbers and revisions.
(depending on the vendor).

Each item also has 1 unique part number (our in-house part number).

I have created my first table like this:

IHPN* : GROUP : IMAGE (y/n) : NOTES

I also have a quote table depending on the time of year prices change:

QuoteID*(autonum) : Date : Source : Remarks : QTY : UNIT : Delivery : IHPN

I have a sales quote table too:

SaleID*(autonum) : Date : Customer : Notes : QTY : Unit : Devilery : IHPN


and lastly I have a table for all the different part numbers avaliable for each item:

PartID*(autonum) : Part No : Revision : IHPN

--------------------------------

My problem is... I'm not sure if I'm on the right track.

Eventually I'd like to make a front end to dispay all of the above information..

am I on the right track?

--
PS: This is a reference tool for us, not really a sales system. We're just using it to help keep track of what parts we have and what we've quoted them at.

[sashi]

Hi there,

heard abt RDBMS?? well.. it's time to put it to test.. :)

ok.. i believe i understood your problem..

1st..
you need to have an item table.. lets say the field ItemID is the primary key..

2nd..
you need to have parts number table.. lets say PartNo is the primary key and make the ItemID as foreign key..

3rd..
make sure to include the ItemID field wherever necessary..

good luck my fren.. :)

[wizzard011]

how do you create a foreign key?

Im new.. sorry :(

[wizzard011]

N/m I'm an idiot.. I didn't think it was working properly.. but that's because I typed the wrong value in and it wasn't showing up.

[sashi]

Hi There,

primary key is the unique key in a table.. ok .. when the same key exist as a on unique key on another table.. thens it's know as the foreign key.. :) see links below for some good examples..

in the case above.. the ItemID is a primary key in the item table whereas a foreign key in the number table.. hope you understand.. good luck my fren.. :)

http://www.campus.ncl.ac.uk/databases/design/
http://www.geekgirls.com/databases_from_scratch_3.htm
http://www.awtrey.com/tutorials/dbeweb/database.php