Hi
i just created a database with people record and a second database which only contains the people record ref number and a waiting list number (which shows how far they r on the q.
What i need to do is, i want the que field to generate numbers automatically from 1-onwards (but dont want to use auto number).. but when i remove like the first person on the que then want the number to automatically change the second person on que to first etc etc. So as i blank the field of the people in the front of the que i want it to change the status of everyone accordingly
- I dont want to delete any of the records either, i just wanna blank the field once the person on the front of the que has been dealt with .
am using ms 97
is there any way of doing this, i would really appreciate it.. many thanks
i just created a database with people record and a second database which only contains the people record ref number and a waiting list number (which shows how far they r on the q.
What i need to do is, i want the que field to generate numbers automatically from 1-onwards (but dont want to use auto number).. but when i remove like the first person on the que then want the number to automatically change the second person on que to first etc etc. So as i blank the field of the people in the front of the que i want it to change the status of everyone accordingly
- I dont want to delete any of the records either, i just wanna blank the field once the person on the front of the que has been dealt with .
am using ms 97
is there any way of doing this, i would really appreciate it.. many thanks
Last edited:
