This topic is locked
[SOLVED]

 redirect not working

11/8/2011 4:10:20 PM
ASPRunnerPro General questions
G
georgeb author

goal: user adds a record to the field rep report table


and is redirected to the Report document Add form with the newly added field rep report record ID field as the foreigh key value for the form. as below


in the after record add added event I have:

Response.Redirect "EIS_ReportDocuments_Add.asp?mastertable=EIS_FldRepReports&masterkey1="&values("ID")

I have also tried

Response.Redirect "EIS_ReportDocuments_Add.asp?mastertable=EIS_FldRepReports&masterkey1="&keys("ID")
the ID field is an int so I don't think i should have to add "'"s around it

the redirect does not complete...ideas?

P
Philip 11/8/2011

Hm... Why do you redirect to ADD page - shouldn't you use EDIT page?

G
georgeb author 11/8/2011



Hm... Why do you redirect to ADD page - shouldn't you use EDIT page?



I may not have been clear...the user adds a report "definition" record to the first table then uploads associated documents to the second (child) table thus the need to pass the parent record id....so how does one "edit" a non-existant record.

G
georgeb author 11/8/2011



I may not have been clear...the user adds a report "definition" record to the first table then uploads associated documents to the second (child) table thus the need to pass the parent record id....so how does one "edit" a non-existant record.



what i would really like is if on the repports add page the report doucments list at the bottom of the page would allow me to add documents but only the cancle icon is there....setting somewhere?

Sergey Kornilov admin 11/9/2011

While I'm not sure about redirect not working I can suggest to add master and details right on the same screen. You can proceed to Master-Details relationship properties and choose to display Details on Add/Edit pages.

G
georgeb author 11/9/2011



While I'm not sure about redirect not working I can suggest to add master and details right on the same screen. You can proceed to Master-Details relationship properties and choose to display Details on Add/Edit pages.



Got it to work thanks