Master Table s/have fields:
ID_NUM (Autonumber and Primary Key)
TRANS_TYPE
TRANS_NUM
TRANS_DATE
Set PK on the ID_NUM and then set unique index on the other two fields (table design view, VIEW-->INDEXES).
Child Table s/have fields:
ID_NUM (join)
EMP_ID
REASON_CODE
DEBIT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.