Hello all. I am having a little issue. I have written a small database for a company that want to contact potential leads for their business. The issue I am having is with a form that is based on a query based on 2 tables. Now, if user 1 edits a record in the linked table, user 2 cannot see these changes and if he tries to then add a some data it fails with duplicate values.
How do I get the form to refresh the data once someone clicks the "Next" button, without it moving back to record 1?
The tables the query is based on are called tblLead and tblCallDetails, the link field is LeadID. When the company makes a phone call, they tick a box for Answer (either yes or no), once this is clicked it adds a record in the tblCallDetail table.
How do I get the form to refresh the data once someone clicks the "Next" button, without it moving back to record 1?
The tables the query is based on are called tblLead and tblCallDetails, the link field is LeadID. When the company makes a phone call, they tick a box for Answer (either yes or no), once this is clicked it adds a record in the tblCallDetail table.