I am making an email function for my database. My database has a table with all the necessary feilds email, contact name, company etc. This is all in the backend of my table. Currently i added a checkbox to the table so that you can select a list of email address as the recipients. the problem is that if more than one person is using the email list they are editing the same thing.
My solution is to create a local table (in the front end) that contains the checkbox and is linked to the contact name so that each user will have thier own local version of the table.
My problem is that I don't know how to link the tables (one in the front one in the back-end) so that when new contacts are added to the back end the list in the front end will have the added contacts.
Thanks