Dispatch Date calculation
FMPro10, Shared, Windows
I'm trying to create a calculated date for dispatch.
Each of our customers have a specific day of the week for dispatch (text value DayName). This is held in a CUSTOMERS table, related to an ORDERS table by an ID number.
When a date is entered into a [date_complete] field in the ORDERS table, I want to calculate the next dispatch day for that customer, and add this to a [dispatch_date] field.
This would take the complete date [from ORDERS], find the customers next dispatch day [from CUSTOMERS]and calculate the [dispatch_date].
Is this possible? I am having a lot of trouble coming up with a calculation to do this.