I've added a field to the Contacts table so I'll be able to assign credits to my clients for their hours. I've titled that field "Contract Hours."
On another table that I created, I've added a drop-down based on the Contacts table, and I added "Contract Hours" as a linked field (which I named "Contract hours1"). I thought that "Contract hours1" would refer to the value of the "Contract Hours" field in the Contacts table. But for me, linked fields--such as "contract hours1"--are just there. I haven't been able to do any math functions using its value, and when I try to retrieve the value of "Contract Hours" which is located at the Contacts Table and place it in any other field on another table (using an action). I get the following message: "Error Retrieving Value from Table ->Error converting data type varchar to numeric."
What I am trying to do is to create a field in the Contacts table that contains the number of hours that the client purchased. then when I perform any service for that client, I would deduct the amount of time that I spent from the "contract hours" field and then store it in another field which represents the remaining balance.
If anyone has a better or a simpler logic structure, please let me know.
Thank you in advance.