Lock down fields
I have several portals and they have conditional value list.
I have field called fk_id_vessel and it is on the vessel assignment portal and when I select fk_id_vessel it show vessel names(all it working correctly) and it displays vessel name in vessel name field. However , if I go into the vessel name field I can change the name and it changes that record on the vessel table. How is the best way to prevent this, I tried prohibit modification on the fk_id vessel but that will not let me add any new records to the portal and I tried prohibit on vessel name but that will not allow me to add new vessel names on vessel table. Any help is appreciated.