relationship for lookups

By agtjazz
September 2, 2009 in Relationships

Share

This topic is 5621 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello

I have a table for accruals (lookup table called Accrual_rate)

And I have a table for Emp_accruals (transaction table). If an employee’s MOS_Balance is 75- they should accrue 11.33 vacation hours.

What is the relationship of the lookup table to the transaction table? And how do I script the lookup?

This topic is 5621 days old. Please don't post here. Open a new topic instead.

You need to be a member in order to leave a comment

Sign up for a new account in our community. It's easy!

Already have an account? Sign in here.

Sign In Now

Share

×

×

By using this site, you agree to our Terms of Use.

I accept