database template

[Tekay]

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

 

[lespaul]

[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

 

[Golom]

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.

 

[Tekay]

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