Many thanks again to you both, really appreciate you assisting with my issues.
Kind regards
Steve
Many thanks again to you both, really appreciate you assisting with my issues.
Kind regards
Steve
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
Hi Steve
Can you upload the database that you have the problem with?
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
Steve07:12 PM
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.
Thanks so much for this Mike, you obviously spent time on this, so I greatly appreciate your help.
Kind regards
Steve
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
Hi Steve
The attached is one way of doing this
Hi Mike
Thanks very much again, this has resolved my problem and I am extremely grateful for your assistance and skill.
Kind regards
Steve