Hi all,
I have an invoice table that has 5 main fields:
client, (connected record from parent table clients)
date_from
date_to,
days (an equation that calculates number of days between date_from and date_to)
cost (an equation that calculates number of days x cost which is taken from a parent table of clients
Can I run a script that will take all clients that fulfil a certain criteria, and for each of those insert a new record based on the two fields on a static form that have date_from and date_to?
Thanks in advance