HI All,
We have a group of clients that all want their own form to fill in their own data. We want those forms to fill copy entries to two other tables. One will be a master table (Cleaned) and the other we are hoping to have a table that shows every input including deletion from the second table.
So each partner will have their personal data. Then we will have a master table that combines all partners' data into one which is being cleaned for duplicate submissions by different partners. The 3rd will be a master that will keep everyone data without being cleaned of duplicates.
Can anybody walk me through if this is possible.
