Hi All
I hope you can help, if I give you a understanding of what I have and what I want to do.
1st - Table one, holds around 10,000 recordes, names and phone numbers and basic address information
2nd - Table two which holds all out customer details eg full name and case details and is used by an admin team
What I was hoping to do was have one form designed from table one and when the agent changes a status it moves the record from table one to table two.
Any help would be great
Cheers