This content has been marked as final. Show 1 reply
Take your pick:
- You can use Import Records instead of a look up.
- You can use two fields for the Employee ID with separate relationships for each field. Use one for the look up and then clear it. Use the other to maintain a link to the Employee table. You can also use record level access control to "lock" individual records against change when the DB is opened by any but a full access user.
- Don't use this method at all. Define a separate "Wages" table related by employee ID. Create a new record (you can duplicate the existing one) each time their wage info changes. Use an "effective date" field to identify which record for a given employee is the current record for a given employee. (You can sort the relationship by this date in descending order and then the first related record will be the most recently dated one.)