Recorset or calculated control?

  • Thread starter Thread starter Crag
  • Start date Start date
C

Crag

I'm trying to create a custom autonumber that increments on a trigger (i.e.
change of name in a text box containing names of staff) so that say 6
records detailing the work of Simon Smith are all number 1, and where the
autonumber only increases to 2 when I pick a new staff member. I can do
this using a recordset but would really like to know if it is possible by
using a calculated control (text box) on my form.

Cheers.
 
Crag,

I guess the standard way of handling a situation like this is to have a
table for Staff Members, where each person is listed only once, and the
number is assigned to each staff member in this table. And then you
have a separate Work Details table, where the Number for the staff
member is a Foreign Key field.
 
Back
Top