multiple indentical records

[Guest]

I am trying to establish an inventry system where items of the same
description need to be input into the database. I would like to add a field
on an input form where the user can input the number of items and the system
generates that amount of identical records, other than an auto-generated key,
for that table creating that number of records. Alternative methods would
also be OK

Thanks
Rob

 

[Jeff Boyce]

Rob

You've explained a "how", but not a "why".

From your description, it doesn't sound like there are any 'distinguishing
marks' to allow apparently identical items to be differentiated. As an
analogy, I could create a table and add one row for each blackberry I picked
.... but I really only care about how many, not any detailed information
about each one.

How will having a separate row for each (of some number of identical items)
help you do ... ?what?! What business need will having these duplicate rows
allow you to solve?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff

The inventory item is wine. It will have fields inc details, etc but will
also have Date_consumed and Drinking_notes fields. These will be updated as
the wine is drunk, hence the standard inventory approach won’t work. It is
important to track the changes in the wine over time.

Thaks
Rob

 

[Jeff Boyce]

Rob

Thanks for the clarification. Now, let me ask a different way...

If you are NOT adding a unique identifier to each bottle, then how do you
know WHICH bottle of '74 Lafitte R. (from the 3 cases you stored) you are
referring to with any given row in your table?
(sorry if that wasn't a particularly good year...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff

Thanks again for your interest. Unique bottle is not the main issue, it is
keeping track of the no of bottles in the cellar, dates drunk and drinking
notes. Have been thinking further, guess I could set up a seperate table to
track these with a decremantal index as they are drunk.

If you have any other thoughts, I would appreciate them

Rob

 

[Jeff Boyce]

I guess I'm back to wondering why you are setting up separate rows, if you
have no way to uniquely identify which bottle the row refers to...

Regards

Jeff Boyce
Microsoft Office/Access MVP