Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16
    Many thanks again to you both, really appreciate you assisting with my issues.

    Kind regards



    Steve

  2. #17
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16
    Hello

    I am back again! Now struggling with why the Orders table will not update with content entered in the frmNewOrders form. I can see a relationship between the two, but I have failed to understand how to get the two to be synched.

    Thanks if you can assist.

    Regards

    Steve

  3. #18
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Steve

    Can you upload the database that you have the problem with?

  4. #19
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16
    Hi Mike

    A copy is on this thread updated by Paul 24/11/2019 09:11, and I think it is the same on the file you also uploaded on the same thread.

    Regards

    Steve
    07:12 PM

  5. #20
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You need to open "frmProductCategory" and fill in all relevant data prior to opening "frmNewOrders"

    I renamed a few Primary Keys and also removed the lookup fields from some tables.

    The attached now works as expected.
    Attached Files Attached Files

  6. #21
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16
    Thanks so much for this Mike, you obviously spent time on this, so I greatly appreciate your help.

    Kind regards

    Steve

  7. #22
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16

    Table with Auto Populating Fields

    Hi Mike

    Thanks again for what you produced on my last post, but I cannot achieve what I am after so I can run reports against the Orders table. On the simple d/b attached, I want the tblOrders to show the ListCost associated with a Product Category and ProductName when it is selected (based on what is contained within the tblProducts), if this is possible? I cannot seem to get the relationships right so this works.

    Thanks again if you can assist.

    Regards

    Steve
    Orders.zip

  8. #23
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Steve

    The attached is one way of doing this
    Attached Files Attached Files

  9. #24
    stevebp is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    16
    Hi Mike

    Thanks very much again, this has resolved my problem and I am extremely grateful for your assistance and skill.

    Kind regards

    Steve

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  2. Replies: 6
    Last Post: 12-03-2017, 02:23 PM
  3. Replies: 8
    Last Post: 09-02-2016, 06:08 AM
  4. Replies: 5
    Last Post: 12-09-2014, 01:36 PM
  5. Replies: 2
    Last Post: 02-09-2012, 04:31 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