Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Question Unanswered: need help with variable data in lookup list

    Hi all



    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.

    eg:

    -----------------------------------------------------------------------

    Job Number:

    Date:

    Model Number:



    Part Number Description Quantity Batch Number

    1)

    2)

    3)

    -----------------------------------------------------------------------

    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 everyone for your great help.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Send a short example of this mdb. (access 2002).
    What is the primary key in this tables?
    What is the relationships?

  3. #3
    Join Date
    Jan 2010
    Posts
    4

    Question

    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...

    link for the database:
    2shared - download B747 Spares.mdb

  4. #4
    Join Date
    Jan 2010
    Posts
    4
    think the link doesnt work..heres another:

    Download B747 Spares.mdb, upload your files and earn money. Spares.mdb

  5. #5
    Join Date
    Jan 2010
    Posts
    4

  6. #6
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Attach the file on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •