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"-- 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 an y field on another table (using an action). I get the follow message: "Error Retrieving Value from Table ->Error converting data type ingvarchar to num e ric."
What I am trying to do is to create in the Contacts table that contains the number of hours that the client purchased. 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 l ogic structure, please let me know.
Thank you in advance.