Quote Database Dilemma

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

Scott Viney

G'day All,

I have created a database to quote on dental products. And all works well
so far. But have come a lil unstuck.

I have been told that we need to be able to have products that we dont
quote. EG A company wants us to quote on some drill bits that we dont
stock. We still need to add this information to the report saying we dont
stock it with no prices.

Any ideas how I can organise a table or some other ways of doing this. I
dont really wont to add these items to my products table.

Any help would be appreciated,
Scott V
 
The way I would go about this, add a field to your product table called,

stock_item yes/no

then in all cases you can filter on items that you hold in stock, don't hold
in stock, everything.

In my view this is the least most painful way of solving your problem,
otherwise you are looking at a second table for non stock items, and having
to deal with the complexities of linking that in to your current solution.

I know you don't want to add these items to the products table, but it is
the way to go.

e.g.

Select * from Products Where stock_item=yes
 
Back
Top