I have two virtuals that run selects:
SELECT(Shift Day[Shift Date],
AND([Name]=[_THISROW].[Employee],
[Shift Date]>=[_THISROW].[Start Date],
[Shift Date]<=[_THISROW].[End Date]))
The “Employee” in the form I would like to change to a ref, currently it is a Name type. When I change to ref or enum, the virtuals disappear, then reappear when I return the column type to a Name.
Why are the virtuals disappearing?
Thanks!