AnsweredAssumed Answered

Need some help on adding fields up

Question asked by RobMartin on Jun 19, 2009
Latest reply on Jun 22, 2009 by RobMartin


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