 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007multiple indentical records
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 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 >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 [quoted text clipped - 8 lines] > Thanks > Rob 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 > Rob > [quoted text clipped - 27 lines] > > Thanks > > Rob 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 > Jeff > [quoted text clipped - 44 lines] >> > Thanks >> > Rob 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 > Rob > [quoted text clipped - 58 lines] > >> > Thanks > >> > Rob 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 > Jeff > [quoted text clipped - 78 lines] >> >> > Thanks >> >> > Rob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.