Need some help on adding fields up
I have a table (WorkersDB) with the name of the person and the company he is working for. For every new person added to the list, I just have a field with the company, which can be selected from a value list ("CompanyList") or a new company name can be entered - CompanyList is defined as "use values from field company".
Now I have created a table (CountDB) to sum up who many people work for each company. My problem is now, that new added companies have to be added manually to this list - I would like to have a script checking the value List "CompanyList" and checking if all these entries are resembled by one record in the CountDB and if not create one record.
Thanks for any advice