Not really. What I am trying to do is show the amount of devices purchased, the amount of devices used and then what is left over. I have a table called Workbook and in this table I have several fields that have to do with phone configuration. The field names are "Phone Type" and Phone Model". The phone types have 4 to 5 different phone models. Example OP5 is a Phone type or phone family and under this family there are 4 models. It is important to keep this seperated. I have a total of 3 Phone types that can be entered. I built a query from my Workbook table to group by types and models and give a count of each combination of Phone Type and Model. I then created a sub-form and placed in my form called DataEntry. On this form I use macros to allow an easy way of entering all the information for the device being entered and the end of the macro I do a refresh this way my sub-form gets updated. I did this so the user can see at at glance how many devices and of which kind they have created. This all works great. My problem is in giving them a Delta or what is left of the purchased qty.
I have another form called CustInfo, this is where I have the fields to enter purchased qty. I only used one field for the Phone Type and model, example; OP5 Standard. So I can't link these fields because first on the custinfo table these fields are number fields and in the workbook they are text fields.
Any ideas on how I can provide this very helpful information to my users.
