I have a work table that captures client, date, description, and hours. I also have a timesheet table that captures client and period ending, invoice #. I’d like to be able to link timesheet to work on client and work between period ending and period ending - 7. Is this possible?
What if you add a field on each table with client and period (you can use concernate for that)?
I was hoping to avoid having to include the billing-related information in the work table.
I could probably calculate the Monday of the week for each date, then use that as the reference field.