Hi Richard
I have a database that,
I have TABLE for customer ID ,Surname,Name and Address and
I have TABLE with customer visit and records what he she coming to do on daily basis.
I created a form for Customer ID,Surname,Name and address and
I created a form for customer visit what time and date and what he/she coming to do and I created a sup form.
But may question is that,
I have 4 consulted (USRES) to assist the customer as follows;
1.user register customer information on the database and the reason for visit, date and time must recorded to see what time customers was registered and wait on the waiting room for the next user (consultant)
2.Second user (consultant)will call a customer and record what time he/she call a customer and check documents if all correct the capture information of a customer then send to the next user(consultant)
3.Third user (consultant)will call a customer and record the time then verify all documents and sign or approve application. then customer go home.
Can I split to do three table for each user and if so how I link to customer ID
I don't know if you understand me or if is there anyway I can sent you my database to see
Remember I still new and learning

---

Reply from Richard Rost:

I see a need for 2 tables: a customer table, and a contact history table. The details on your calls will be stored in the contact table.

Sure, you can send us your database if you want. Submit it via the TechHelp page.