This topic is locked

multipart add / edit crossing tables

6/5/2012 6:01:01 PM
ASPRunnerPro General questions
M
mfred author

Is it possible to have ASPRunner cross over multiple table entries for adding and editing? I have a project that will require too many fields for 1 table. So I want to split the project into multiple tables. Let's say that the main table is an events table. The initial step is to add an event or edit an existing event. So the first add / edit form will be for the event itself. When they submit that, the event table is updated and the next screen would be an event needs table. The field that would connect between the tables is the event ID. When adding an event, the event ID from the first form will carry over to the event needs form. When editing, the Event ID will pull up that events needs for editing. After the user updates the event needs table, the back to list option will take the user back to teh events list.
A related part would be the view link for the event. I am using access for this so the max number of fields for even queries is 255, as I recall. So the event view page would neen to be able to view details form multiple tables.

Sergey Kornilov admin 6/6/2012

I guess you can use something like this AfterEdit event of the first table:

Response.Redirect "secondtable_edit.asp?editid1=" & keys("EventID")


This code assumes that both tables have a primary key named EventID.
Then you can add something similar to AfterEdit event of the second table to redirect user back to the list page.