Richard,

(I am still working with Access 2002/2000 data settings)
Working on my Winecellar Database I would like to make the table, form and queries for the wines “in stock”.  I would like to enable myself to make a difference in categories; wines to drink asap; wines Short Term Stock; wines Long Term Stock (not to drink before 2025) and wines to drink in a certain year (by a box and drink one bottle a year for instance).
This last just to be able to follow the maturation process for certain wines over a number of years. I want to be able to know how many bottles I have reservated for next year to figure out how many bottles I would need to buy to have enough to drink next year (within a margin of what my consumtion normaly is)

Question 1:
How to proceed to keep the number of wines in stock up to date?
One Table or different Tables? (General Dates and a separate table for the options LongTerm, ShortTerm etcetera with a list box on the Form).

Question 2:
It would be nice to have a possibility to duplicate (part of) a record.
The tasting notes for example; most wines I follow over the years by tasting them every year. I know I can copy them within the form easily but then a number of field I have to overwrite with the new data like year, the value I give that year and the notes. (in detail also the acidity, alcohol percentage, sugar percentage and so on.
Is it possible and how to do so?

As always thankx for your time and anser(s)
eddy

---

Reply from Richard Rost:

1: There are several ways you could do this. If you have a situation where you have unique items (with a serial number, for example) then I would place each item as a separate record in a table. You probably don't have that situation, however, and could probably get away with each record representing a "type" of item, such as the brand/year of the wine. You would then just assign each wine a category (separate category table) and a quantity on hand number.

2: You can copy a record with a little bit of VBA code. Since my Access students are always looking for little projects to do, I'll leave this to them to answer. You can do it one of three ways (that I can think of). You can either use DoCmd commands, a Recordset, or an Append query. Let's see who can figure this one out.