I have a 'product waitlist' table that holds the following fields:

Record id (auto enter serial number)

Creation Date (auto enter creation date)

Creation Time (auto enter creation time)

Customer name

Product wanted (via a drop down value list)

I would like to have a field called 'position' which shows the customers position on the waitlist based on what product they are waiting for- this will have to be relative to the date and time the record was created. When the customer collects the product , the record will be deleted so it needs to be able to recalc when this happens.

Any ideas on how I go about this?

thanks

Edited March 10, 200916 yr by Guest

sort the records desc. by date and time then record number is position, If you want to store positions use replace records command.

See if this helps:

http://fmforums.com/forum/showpost.php?post/317490/

thanks, that example was very helpful and I have managed to modify it to solve my problem.