Loved the video. Very nice explanation. Thanks so much. Only thing, its a bit hard to see the dark mode. Maybe in future videos change it to be able to see it better. Other than that, Great!!!
Nice video I've been trying to solve a problem with a project im working on. Lets say I have a customer table {Customerid, name, first_oder,Last_order} and an Orders table {custid, prod_name, order_date}. I want to copy/paste the first and last order for each customer. A customer can have multiple orders with mutliple dates. Thanks.
@@thethinkstudio1200 so I want to copy the information (first and Last order date) from the orders table to the customer table. So I could use data from their first order and last. I was playing with Min(orderdate) and Max(orderdate), but I believe I may need a loop to check all the orders for a specific customer and pick the first order date and last. Thanks.
EXTREMLY HELPFULL
Cameron, my friend. Great vid. Please do more !,
Loved the video. Very nice explanation. Thanks so much. Only thing, its a bit hard to see the dark mode. Maybe in future videos change it to be able to see it better. Other than that, Great!!!
Thank you for the feedback!
I believe this works but I have got into a bit of a situation as my table doesn’t show my fields? How can I make it show?
need to allow the creation of records in the parent or child record.
I have tried and it has now said I need to make a valid value
@ email me your file to take a look at not given enough details.
Cameronmaciel97@gmail.com
@ it sounds like you have a table occurrence issue. With which table you have on the layout vs the table you are referencing in the script.
Okay I have sent. Possibly it doesn’t work with my fields as I’m not doing address and stuff
Nice video I've been trying to solve a problem with a project im working on. Lets say I have a customer table {Customerid, name, first_oder,Last_order} and an Orders table {custid, prod_name, order_date}. I want to copy/paste the first and last order for each customer. A customer can have multiple orders with mutliple dates. Thanks.
When you copy the first and last order from one customer where is that info you copied going?
@@thethinkstudio1200 so I want to copy the information (first and Last order date) from the orders table to the customer table. So I could use data from their first order and last. I was playing with Min(orderdate) and Max(orderdate), but I believe I may need a loop to check all the orders for a specific customer and pick the first order date and last. Thanks.