Thanks for the reply Zachh.
If I make period_from or period_to as prime key it will allow me to enter data for employee a but it then it will not allow me to enter data for employee b
Thanks,
Allingame
allingame
Last Activity: Jun 30 '08, 08:22 PM
Joined: Jun 22 '08
Location:
-
I am using MS-Access...Leave a comment:
-
Need help with append and delete duplicates
Hello Friends,
I Need help with append and delete duplicates
I have tables namely
1)emp, 2)time and 3)payroll
TABLE emp
ssn text PK
name text
regular_rate number
ot_rate number
TABLE time
regular_hours number
ot_hours number
period_from date/time
period_to date/time
check_date date/ti... -
Need help with append and delete duplicates
Need help with append and delete duplicates
I have tables namely
1)emp, 2)time and 3)payroll
TABLE emp
ssn text [U]PK[/U]
name text
regular_rate number
ot_rate number
TABLE time
regular_hours number
ot_hours number
period_from date/time
period_to date/time
check_date date/time
...
No activity results to display
Leave a comment: