Hi there,
I need some suggestions on how to do the following:

A list of members are listed from database.
Admin User can select which of these members was present at a meeting. Using either checkbox next to each member or by use of a list box where members are listed in this box (I'd prefer the checkboxes)
Selection is submitted into a table that cross links memberID and eventID
eg. id(autono.) EventID MemberID
1 1 1
2 1 4
3 1 8
5 2 2
6 2 3
7 2 4
8 2 8
Next it only list these members that where attending (new recordset)
Admin User submits scores of these members eg. bridge scores or fastest time...

It seems that all I need to do is a simple loop to inser or update the individual records.

Question is how?

Any ideas? Does anybody know of a good tutorial to explain this to me?

Thanks
JB Willers

Hi JB

Here's an actual example for an app under dev at the mo, eventually the SQL will be in a stored procedure before going to production:

On the FORM all checkboxes have the same name, this means all data comes across in one string.

Do you understand what's going on here or do you need a step-by-step?

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
&lt;font size="1"&gt;[ Studio MX/MX2004 | ASP -&gt; VBScript/PerlScript/JavaScript | SQL | CSS ]&lt;/font&gt;

Edited by - Digga the Wolf on 06 Jun 2005 14:05:21

Hi there Lee,
Thanks for the response. I was beginning to think that I'm just a complete dolt and that everybody out there, sees this as obvious stuff that one should know or otherwise should not bother with design in the first place.

I get the gist of what you're doing and will try it on my page. I expected that I needed some form of procedure (that uses a loop) to get the job done but had complete "programmer's block" with regards to the whole thing.

My project folder is bursting from its seems with "Test14b.asp"-pages.
Point is...Thanks. Will try it. Sure it will work. Thanks.

JB

This may help you as well:

www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=1714

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>