I am new to QV and at the moment I am building my first app. The content in this community is a great help so far.
Maybe you can help me with my next problem as well:
I have two tables "Loadings" (at different warehouses) and "Deliveries" (to customers). Unfortunately these tables have no clear connection.
"Deliveries" consists only of "CustomerID", "DeliveryDate" and "TourNumber".
"Loadings" does not contain a "DeliveryDate" but a "LoadingDate". This date is a few days before delivery or at the same day.
The same "TourNumber" is often used more then one time and not unique. "CustomerID" is included in "Loadings" as well.
My idea is to allocate the loading date to my "Deliveries"-Table with a loop-function which finds the last (Max date before delivery) "LoadingDate" allocated to "CustomerID" and maybe "TourNumber".
Do you have an idea how I can create this in my script?
