Record position number calc

[Robert Collins]

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, 2009 by Guest

[Osman]

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

[comment]

See if this helps:

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

[Robert Collins]

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