L
Lozza0409
I have forms which allow the user to select criteria. The result is displayed
in a report. One of the parameters is a start and end date. I want to allow
the user to take these dates and assign the values of the results to a table.
My database doesnt work like an order and order line but it is similar.
What happens is the user needs to enter the daily work load for all staff.
Once this is done invoices are produced on a weekly and monthly basis. the
form paramters allow the user to select the type of work and dates to invoice
for. This all works fine, but the user should be able to store the invoice
details and it should be link to the relevant work that has been selected.
When entering the daily work details the use does not know what invoice this
will be part of yet so cannot specify this. What i need to do is allow the
user to enter the work details and then select the dates and invoice type and
run the report. This data should then be extracted into a table which
generates an invoice ID for the report.
in a report. One of the parameters is a start and end date. I want to allow
the user to take these dates and assign the values of the results to a table.
My database doesnt work like an order and order line but it is similar.
What happens is the user needs to enter the daily work load for all staff.
Once this is done invoices are produced on a weekly and monthly basis. the
form paramters allow the user to select the type of work and dates to invoice
for. This all works fine, but the user should be able to store the invoice
details and it should be link to the relevant work that has been selected.
When entering the daily work details the use does not know what invoice this
will be part of yet so cannot specify this. What i need to do is allow the
user to enter the work details and then select the dates and invoice type and
run the report. This data should then be extracted into a table which
generates an invoice ID for the report.