By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

Creating a Item / Quote / Sale Database

P: 8
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?
Jul 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: 8
PS:

This database is more for a reference tool than a full-fleged accounting system it's just used to lookup the part to see if we have it and what prices we've been quoting. So it's going to be rather simple in the end.
Jul 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.