Hi all,
Trying to create a database that does the following:
1 - Each crew member has their own line, and within it you can select what they are doing from a dropdown menu each day
2 - Have a report that summarises who's doing what on a given day
3 - Based on today's date ie 18-8 create a dynamic "Generate Document" form. I figure I do this in the report page - but when I change the column of the date, I need to edit the "Generate Document" file to represent the date I want