The database is used for customer relationship management.
I have company records with phone numbers, company name, market they work in, email, web viewer of the company website, notes field to enter details of contact with the said company.
When using the database, for instance, doing a marketing exercise to companies local to London, first I select companies in the London region, then I go through the companies, and check "I need to call" if it is a company that may be interested in the marketing call.
Then when I have this narrowed down list. I go through the companies A to Z calling them.
This issue is now, when someone else is making their own list, and our narrowed down groups overlap their is no way of knowing who should be calling who.
I tried to work out a logical design, and the last post was my best idea, but I thought that as FM is a powerful database there maybe a standard way of making the database functional for more than one user.
Each time you select a company as one that you need to contact, you should create a record in a related table. These records can auto-enter an account name or User name so that the records created by you are labeled with your name and the records created by your coworker are labeled with their name(s). That then allows you to pull up a list of just the companies you need to contact that omits the records created by others. Once you have made that phone call or other contact, you can click a check box or something to mark that record so that it cannot be pulled up in your list the next time you ask for it.