Results 1 to 2 of 2
  1. #1
    chacal33 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    May 2016
    Posts
    1

    Lock child field when parent field is changed on condition

    I am new to this forum and so far I have managed to find answers to all my questions for my access project.
    But I got stuck. I tried various options but they did not work...

    I have 2 tables:
    T_Product
    T_Transaction


    where the ProductID is the link.

    And 1 query:
    Q_Transaction
    from which i get the value of the transaction

    When i change the buying price in T_Product, depending on the date i changed this price, i would like the price in Q_Transaction to update or not... Because, obviously, last year's transactions have not had their value changed.

    I am sure it is a very common topic, but for some reasons, i just cannot work it out.

    Thank you kindly for your POVs on this.

    Matt

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    asked and answered here

    http://www.access-programmers.co.uk/...d.php?t=287019

    Matt - not sure why you are asking a question when you acknowledged on the other thread that the answers were helpful and just what you were looking for

    For the future, recommend you take a look at this link

    http://www.access-programmers.co.uk/...d.php?t=287019

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-23-2016, 09:15 AM
  2. Replies: 1
    Last Post: 03-26-2015, 10:59 AM
  3. Replies: 7
    Last Post: 01-21-2014, 11:32 AM
  4. Replies: 3
    Last Post: 07-03-2013, 01:20 PM
  5. How to make Parent field store sum of child fields
    By Alexandros in forum Database Design
    Replies: 10
    Last Post: 03-19-2012, 10:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums