0

Locking and protecting records in a table

Hi Guys

I have say a contact table that stores information on an employee, as part of that table I have a link from which contains competencies from another table. I can successfully add a competency to an employees record but if I chose to delete that competency later from the employees record, it also deletes the competency record from the competency table where its linked from. I don't want this to delete from the competency record/table just from the employee table. As deleting it from the competency table means another employee record cannot search that competency as its been deleted. 

Hopefully this makes sense as its a bit of a mouthfall. I am new to this so any dummies guide would be useful. 

Thanks

Andy

3 replies

null
    • ashuk38
    • 2 yrs ago
    • Reported - view

    Thanks, guys for your replies. Fred I have managed to create a 3rd table and use it as a reference between the other tables and seems to be working as needed. Didn't realise I needed the third table but now understand why. I can just simply unlink the competency without it deleting itself so the standard competency can be used again. After your suggestion, I found the following video on youtube at https://youtu.be/SmbtXjmsi_o in case anyone has needs to know.

    Took me a while but that suggestion put me on the right path. Thanks

    • Fred
    • 2 yrs ago
    • Reported - view

    Sounds like you need to create a third table "employee competency" that could be a child of employee. There you would have a reference field to employee and one to competency. You can add any other fields you need to track, i.e. date or notes.

    Now if you delete a competency from "employee competency" it will not delete the record in competency.

    Or if tracking competency by employee is not important or you only have 1 or 2 per employee you can always use the Dynamic Choice or Multiple Choice field. There you would point to the competency table and use the competency name field to display.

    This way you can add new competencies quickly by adding a new record. And you can just deselect the competency if you don't care for it the be associated with the employee.

    • Lars
    • 2 yrs ago
    • Reported - view

    Have you tried unlinking the competency? This might only work on a Mac/Browser and not in the phone/ipad apps, but unlink is the key.

    If you want to remove the link in a script, just set it to 0.

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 112Views
  • 3 Following