What I would personally find useful under a product record is a Manufacturer or Supplier field. Perhaps even some extra fields so that you can enter the Supplier Tel: and Email for re-ordering.
Sometimes I can't remember where I have got a certain product from so it would be useful there. Also, I generate some queries against the DB so that I can pull of stock by supplier but they only way I can currently do that is to use a prefix in Product Code field to something like ABC-12345. Meaning ABC might be the supplier and 12345 the product number.
A dedicated field or fields for keeping Supplier info would be useful. Then again I realise that that would require a Supplier Table and a relationship to the product so may be a bit more involved.


Reply With Quote


