I would like to have a form that when a new record is created it works out the next reference number relative to certain details..So i would query the table for all the related records, sort those in order and take the most recent record based on the previous reference number and then + 1.
In theory seems easy..but..how would i do that in a form?
Sorry if that is a really thick question!!
Cheers for any guidance,