Hey,
I don't think I'd be able to share the spreadsheet on here in open due to possible sensitive data. unless theres another way of sending it to you. But basically the spreadsheet has the data which are on the ASE Form. The spreadsheet has a few more fields/headings on there which arent needed, so will be ignored and not imported into the DB. Some of the headings need slight adjustment to match those fields on the form. The user will modify the spreadsheet to match the headings of the DB. The data will update the records in the DB. AS i mentioned in a private message I sent to you, the DB will consist of two main forms - the ASE Unit Form and the SimSerials Form. The DB is to record and locate where all the ASE Units are, their history and what Serial Number is attached to it. Every ASE Unit will have a SIm Serial Number and not every SimNumber will have a ASE. Hence there can/will be more Sim Serials than ASE Units recorded. The Spare "Unassigned" SimNumbers will be entered into the Sim_Serials Form. while everything else will be in the ASE Form.
When A SimSerialNumber and a ASE unit is entered in the same record. The SimNumber's status needs to change to "Assigned" automatically in the SImSerial form/table. Any Sims which are damaged/faulty will be entered into the subform of the Sim serial Form as cancelled with the necessary details. The ASE Unit on the ASE form can then be updated with a new sim. (a new sim can be "assigned"in the ASE Form from the "loose/unassigned" ones in the Sim Serials form). If that makes sense.
All this is currently working to as far as my ability goes.
I just need to know how to use a update query and update/populate new records - and having the Status change in the Sim Serial form when a Sim and ASE Unit is entered in the ASE Form. or tables?!?! depends how the query works I guess. Don't know much about the full use of queries yet or the many types going.