Unanswered: need help with variable data in lookup list
I am a first time user of the microsoft access 2003 im currently stuck with my work and help of any kind would be greatly appreciated.
I am trying to create a database to track my spare parts' batch number. I would need to keep a record of which batch number have been used in which particular repair job. I created two tables in access one called 'model number' and the other one called 'spares'. I made a lookup list which looks up the spares list which i have made.
I would only have to key in the model number and the list of spares required appears at the bottom as a subform.
This is where it gets tricky. When i enter the batch number for a a certain record, it saves correctly and i do not have any problems. However as i add a new record with a new batch number, access updates all the previous records making them all have the same batch number as the new one. Would it be possible to make access save the lastest batch number without affecting the previous records? and would it be possible to search which jobs have used a certain batch of spares?
Thank you for your prompt reply..i am a total newb thus i do not know how to describe to you what i have done. However, i have attached the db for your reference.. take a look at it thank u! oh initially i could edit the spaces in the form, but now i do not know why i cant anymore...it kinda changed over the weekend..sigh...