How to

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I have Access 2000 and I am creating a database of my
inventory, one of the tables is going to be for items sold.
When I mark that item sold in the main table or form, how
do I get access to take that item and all of it's
information and insert it into the sold table and out of
the main table? So I dont end up with the info in 2 places?

I am a beginner with access so help please
 
In code behind the "Delete" comand button, execute a query to append the
data to the "sold items" table and another to delete it from where it was
stored before. Alternatively, you could use a macro, if you don't do code.

Larry Linson
Microsoft Access MVP
 
If the information is identical, use one table. Create
a query on the main table. To the new query add a
criteria for the item-sold field. The criteria would be
the value entered to indicate a sold item. This query
would give you only the sold items.

If you want only inventory items, create a new query and
add a criteria item-sold field. The criteria would be the
value entered to indicate an inventory item, which may be
a null (use IsNull). You can then use this new query as a
record source to your main table.
 
Back
Top