Afternoon Everybody,
I'm sitting with a sticky one and was wondering if anybody out the can help me out.

Ok here goes:
I've got a DB with the following tables: tblMembers, tblEvents and tblMemberEvents.
tblMemberEvents is a crosslink table that cross refs which "Members" was at which "Events".
Ok now listing these records are easy but Updating or Inserting records is getting my wiring all twisted!

Question1: <b>Inserting new Member/Event Data</b>
Inserting new data in tblMemberEvents should consist of:
1. Identifying the event I want to insert/add (asume that the event already exists in tblEvents)
2. List ALL members with a checkbox to indicate if they where present or not.
3. On Submit write to tblMemberEvent all the MemberID that where Checked.

Questing: How the Hell do I do that?

Question2: <b>Updating Member/Event Data</b>
1. Identify Event
2. List all Members with checkboxes
3. Populate checkboxes where Member was at meeting according to tblMemberEvent
4. After changes to checkboxes are made I assume update is similar process to the insert/add process?

Question: How do I do the populate thingy and thereafter the Update of the database?

This seems to be a tricky and maybe long explanation. I anybody can refer me to a site/page that explains this I'd be very thankful.

Thanks
JB

First, what database are you using? MS Access? SQL Server? other? Also, for clarification, you're using regular ASP, not .NET correct?

DMXzone is has a couple tutorials/articles about "multiple update with checkboxes." Again, I'm not sure what DB you're using so go ahead and search DMXzone real quick and you'll find what's available.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

Mmmm...Sorry about that.
MS Access DB & normal ASP.
I'll see what I can find wrt the tutorials ELSE I'll bother you again.
Thanks
JB

OK seems that this topic is answered by this discussion:

www.dmxzone.com/forum/topic.asp?TOPIC_ID=18128&FORUM_ID=3&CAT_ID=2
JB

This article/sample code does not even include checkbox in the example.
I'm now going to check out :
www.webthang.co.uk/tuts/tuts_dmx/rob8/rob8.asp
Will let you know.