Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database template

Status
Not open for further replies.

Tekay

MIS
Oct 25, 2002
24
US
Is there a database application template for access 2000/02 to sell unique items?
I need to setup a database to sell unique items#'s (like plots of land) and to make sure that I do not sell the item to more that one person. Also, after I sell the item, how do I lock the entry so it does not allow me to change it. I'd prefer to do another entry to create a negative sale or 'return'.

Thanks
Tom
 
[facetious] I thought the point was to sell the same plot of land to different people over and over?[/facetious]

set up your user interface to not allow deletions or changes to a "sale"; create a new negative "sale" for returns.

once you have "sold" a plot, indicate in your plot table that available for sale = 'N' or False.

HTH

Leslie
 
Don't know about a template but the usual approach is to place items for sale in one table (call it "InStock") and place items sold in another one (the "ItemsSold" table). When you sell an item, move it from "InStock" to "ItemsSold". If it is returned, move it back. Display only what is in the "InStock" table when the user is making a sale.

The other approach is to use a "QuantityInStock" field in the "InStock" table. Decrement that count when an item is sold and do not allow further sales when it hits zero. You will still need an "ItemsSold" table to record things like "SaleDate", "Customer", "SalePrice", etc.
 
Thank you guys very much..you have given me a lot to work with now.

lespaul, nice!

Golom,
I do not know how to write codes, that's why I was asking for a template. I like you suggestions about the stock db and the sold db etc.
I know how to do those and I also know how to do the sales table to record the sale.
What I don't know is how to 'move' the item once it's sold. Can you help me with that. Guess it will be a macro but don't know where to trigger it and what command to give the macro.

Thanks again..
Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top