I've built myself a database to control my very small business. On one of the tables, I have all my purchases. On another, I have all my sales.
When I go into sales, I select an item from my 'purchases' table via drop down that I've sold. HOWEVER, what I can't figure out is how to set things up so that once I've sold an item, how do I stop it appearing at a later date on my pick list on the sales sheet i.e. I've already sold it so I don't want to be able to 'sell' it again.
I guess that I've got to find some way that, once it's picked, a marker gets added to the purchased table that says 'no longer available', and the sales sheet disregards all items with such a marker.
But I can't work it out. Without going in an manually updating the Purchases table every time. There must be a smarter way.
Answers in relatively plain english please - I'm self taught (recipe for disaster!) and Access makes my head hurt!
2007-06-30
21:57:53
·
6 answers
·
asked by
Anonymous