Product-v6.fp7

<div>
Thank you for the advice and solution.I have been busy with other apsects of the application and set up the sequencing &nbsp;of events today.It looks like it is working and may need a few monor adjustments to suit the exsisting data.
</div>


Thank you for the advice and solution.I have been busy with other apsects of the application and set up the sequencing  of events today.It looks like it is working and may need a few monor adjustments to suit the exsisting data.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I would like ot have a script that will check the sequence of events in a portal.<br />
The numbers must always be consequtive Starting from 1 and followed by 2 , 3 ,4 etc .I would prefer not to set a limit to the number of sequence steps.<br />
The portal is sorted by Event sequence and the user will need to change the order frequently so the script must reset and and alert if they have set as in the attached example..Number 4 , twice.Or better still that the system will not allow it.(The User assigns the Event sequence Number)<br />
Look forward to any ideas on this.<br />
Thanks<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/05_w21/577093/Product-v5---EVENT-SEQUENCE.fp7" target="_blank" class="file-inline" title="Event Sequence (112 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Product-v5---EVENT-SEQUENCE.fp7</a>
</div>
</div>


Product-v5---EVENT-SEQUENCE.fp7

Hi

I would like ot have a script that will check the sequence of events in a portal.
The numbers must always be consequtive Starting from 1 and followed by 2 , 3 ,4 etc .I would prefer not to set a limit to the number of sequence steps.
The portal is sorted by Event sequence and the user will need to change the order frequently so the script must reset and and alert if they have set as in the attached example..Number 4 , twice.Or better still that the system will not allow it.(The User assigns the Event sequence Number)
Look forward to any ideas on this.
Thanks

Sequence Check

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.