I think a check will also work but I second triggers.
Thanks,
~Ben
On Wed, Aug 7, 2019, 2:21 PM Rob Sargent wrote:
>
> On 8/7/19 12:07 PM, stan wrote:
> > Have table that contains employee keys, paired up with work type keys
> > (both foreign keys) and a 3rd column that you enter a billing
On 8/7/19 12:07 PM, stan wrote:
Have table that contains employee keys, paired up with work type keys
(both foreign keys) and a 3rd column that you enter a billing rate in.
Then I have a table where employees enter their work. I need to validate
that the employee, work type pair exists,
On 8/7/19 11:07 AM, stan wrote:
Have table that contains employee keys, paired up with work type keys
(both foreign keys) and a 3rd column that you enter a billing rate in.
Then I have a table where employees enter their work. I need to validate
that the employee, work type pair exists, b
