First thanks to everyone who has helped with my questions. I am learning a
lot from this project and much of it is from the kind help of people on the
list.
I know that is what the list is for, but I just wanted to say thanks.
So on to the next thing.
I need to make sure people do not sign up twice for the same course. I don't
want to even bother them with a message if they do I just want the who
insert step to be skipped and a result to show that says You were already
registered for this course. Please check you current course registration
list before you select a course. Or I might not even bother with that and
just use the same message as it the signed up the 1st time.
So I do a search anyway when they come into registration that displays their
current course list. I also assign this result set to @@local$currentList
and the count of the rows to @@local$num_currentList
When they select a course from the course list ( a result of a search action
on the 1st form) and then go to detail and then submit that I do an insert
into Staff_Records table of the course they selected and A Cross_Link ID
which allows for inserts of courses that run multiple days.
What I need to do is before that insert check to see if the course_ID is
already in the @@local$currentList and this is where I am a little lost.
Looping through that array looking for a match and then not doing the insert
if their is one.
And is that they best way to do it.
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
215-799-0192
610-256-2843
Fax 413-410-9682
FMP,Tango, EDI,SQL 7
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
