I created a new table called TargetAnimal. In this table, I have 15 animals listed. I linked the TargetAnimal table to the Entity table, Customer table and the Contact table.
On the CRM_Edit Customer screen, I added a drop down field for the target animal. Everything on the edit customer screen works great. I am able to give the customer a target animal and am able to change it if I need to.
The problem: I would like to be able to change the target animal for a customer right inside the work order screen but I can't seem to figure this part out. I linked the TargetAnimal table to the Activity table. When I edit the Add/ Edit work order screen, The target animal screen does show up in the Add Fields but when I add it to the screen, it will only allow me to view the target animal in a txt box. It is not a drop down and it will not allow me to change the txt.
So, I did try to add a drop down box and linked it to the customers table and target animal field. This will pull up my target animal list and I was able to make it retrieve the customers current target animal but any time I try to change the target animal from one animal to another animal for the customer, It doesn't update in the customers table.
Any suggestions. Thanks.