Forms - Is it possible to add a row/record between rows/records

[Keys]

Is it possible to add a row between rows on a form. I am creating a contact list containing phone numbers and groups. I dont want to sort the form out in ascending order, just by group order.

For example:
Joe Teacher (primary school) 12345
John Teacher (primary school) 67777
Ann Teacher (secondary school) 35555
Mary Teacher (secondary school) 388338
Sarah Nurse 373773
Tina Nurse 111111
Peter Footballer 199999
Rob Footballer 888888

Any ideas would be great

 

[KenHigg]

By group, you mean 'Teacher','Nurse' and 'Footballer'?

 

[Keys]

Group

Yeah in them groups, i dont want any alphabet orders

 

[KenHigg]

So you have 'Name' in one field and something like 'Title' in another field that contains say 'Footballer'?

 

[Keys]

Columns

the columns are person, group and phone num

 

[KenHigg]

So if you add a new record and sort on group, you'd have what you need?

(In short, no you can't append a new record in between two existing records. It's a matter of having an autonomous relationship between what the database engine works with and the actual data/records, blah, blah blah... )

 

[Keys]

Sorting

Thanks

I have sorted it into group (in design view) but the groups are now in alphablet order. i need example:
Teacher
Teacher
Footballer
Footballer
Nurse
Nurse

not
Footballer
Footballer
Nurse
Nurse
Teacher
Teacher

 

[Jibbadiah]

Add another field for group priority and sort by that.

 

[KenHigg]

Add another field for group priority and sort by that.

I concur

(or prefix the group name with a 1,2,3, etc..)