hi i have a table and it is like this 1 a 2 b 3 f let's assume i want to add new data {C} so it will be like this 1 a 2 b 3 f 4 c is their any way i make the table look like this 1 a 2 b 3 c 4 f can i force the auto number to change according to the filter applied on the table is their a numeric field can be used instead on auto number that can be changed according to the filters