I have Valets ok
They have assignments (shifts)
They clock in, when they clock out I want them to enter their tips
the tips get added to a column in the assignment table
I want to be able to track the total amount of tips on the valet table
i created a virtual column called [tips] under valet but canโt get it to reference specifically โRelated Assignmentsโ (not every assignment, only the ones they worked)
I canโt reference the virtual column to get the SUM of the tips,
Should I create a new table for โAssignment Dataโ which would include: clock in clock out tips ect or can i reference the related data some how?
LinkedIn
Twitter
