Hello I am attaching a sample microsoft access database.
when you open the database- a form comes up- you will notice the cursor flashing in the second field pre-number-
If you enter a number there - it will fill each record with that number.
If you try to enter a number in the number field- it will reject you- I have found that if i make serial number in tbl2 primary key- it will let me enter number here.
But this is not possible- since serial number has duplicates in real database. ( also only enters same number in all records)
*** it does not matter if you change whole process- just want correct result thank you
what I want:
I want to be able to enter a number into prenumber field and have it populate the next records- UNTILL - I enter another number or exit application.
so it would be like enter 100100 and
pre number number
NOW i change prenumber to 100111
WITHOUT Changing Prior records- the number changes.
I have only those 2 fields to enter into - because - the other fields in form [serialNumber] and [Code] - are already populated before user gets to this form in data entry process.
I need this in next 12 hours- if you can do it - let me know