I have tried to accomplish this seven ways of sunday but with my limited knowledge it is proving more tricky than my skills. Here is what I have and what I am trying to accomplish.
1. A Table with Customer Details
2. A Form "showing" customer details.
Desires;
1. From Combo box - Show dropdown of customers stored in said table.
2. On Selection of Customer from Combo box, customer fields on form populate with coordinating information from form. This combo box will also populate a Customer history that is tabbed to the same form from a table yet to be built.
2A. Or the ability to start typing and smart names come up, almost like a google search does.
3. Ability to edit customer from form which then updates/saves details to table.
4. I have a save, a save and new, a close, and a new button. When I click save, again information in form updates table. If I click save and new, a new Client ID autopopulates from the next available ID that is open from the Customer Details table.
5. Finally if any information has been changed and any button is clicked to navigate away, a popup asks if you want to save change. Such as " Changes have been made to the current customer, would you like to save or discard these changes?"
I know it looks like a laundry list but I wanted to explain it as well as possible. It is for sure above my meager ability. I thank anyone in advance who is kind enough to help someone who wants to learn.