inserting a record between existing records

[hartmut]

:bang: I have to make a database for a friend who has garden shows . there are spaces for each show at specific tables. the majority of the exhibitors are the same and he prints out a roster. the naming is as follows;

1st table = A

the 4th exhibitor = 4

so the printout becomes A;4 = jeremy's garden

in the database it would say

table a

3rd space = Melissa's flowers

table a

4th space = Jeremy's garden

table a

5th space = Patane's Landscaping

but sometimes for whatever reason someone new is inserted between , or ex. jeremy's garden and Patane's landscaping

this changes Patane's Landscaping to number 6 at the table instead of 5 .

He will have to generate a list with the proper assignments and they change all the time . I need a script that will automatically insert the newcomer and renumber the assignments and change the calc data because I have fields which say you are with such and such on your right and such and such on your left. Need some help here.

Edited August 12, 2009 by Guest

[mr_vodka]

You may be able to modify a solution as such to fit your needs.

http://www.excelisys.com/web/downloads/files/PortalLineShift.zip

[hartmut]

thanks