I am not an MS Access person. I have a 3800 row spreadsheet that I want to get into MS SQL, however, I want to see if the vision is correct before I go to the trouble. I have the spreadsheet imported into Access. No problem. I created an entry form to add new ones. I believe. I would like the form to do a couple of things and am not sure if it's possible. What I'd like to have happen:
User opens database and gets form.
User enters an account number. If the number is already in the table, the form is auto-populated with the information from the table allowing the user to change and update any of the fields, as needed. If the account number is not in the table, the user completes the form and the record is added to the table based on a field that is also populated on the form. An example of this is account number 1234 is not present in the table. The form remains blank. All information is entered into the form. One of the fields is a store location. Instead of adding the record to the table at the bottom, it append the record to its specific location. So if we have locations 1-12 and account 1234 is serviced out of store 5, the record does not got to the bottom of 12, but is inserted somewhere with the 5's.
Is this even possible? And if I get it to work in Access, can I import and have the same functionality in MSSql?