2. ASPRunnerPro General questions
  3. Access field values in VIEW
This topic is locked

Access field values in VIEW

 		11/10/2007 9:03:18 PM
ASPRunnerPro General questions
P
 Philip author

Hello
I'm working on a registration system for sports events. In general I have two tables:

a) table_events with all details to the event

B) table_registrations which sholud hold registrations for the events
I'm looking for a solution where someone can click VIEW (or EDIT?) on the event_list; as a result the system shall "read" 3 field values, temporarly save them, hand them over to the table_registrations where user has to fill the rest of the requested data. Finally a new record is saved to table_registrations consisting of events and sportsmen data.
Question: by which event and code I can access field values in VIEW (or EDIT?) ?
Thanks for any help

Philip
P
 		Philip author 11/12/2007

Any idea / input is wellcome :-)

Philip
pbunyon99 11/15/2007

Philip, I think you just need to normalize your two tables so that there is a common field, like EventID between them. Then you just use standard ASP Runner to ADD/EDIT the registration data. Then use a regular query to pull a report with both the Event and Registration data.