This topic is locked

Hyperlink to Details with 2 Criteria

1/7/2007 11:17:29 PM
ASPRunnerPro General questions
K
kconzel author

Hi,

I have 2 "Tables" QryByWeek and TblSignOffs with 2 common fields, Week and Campus. The QryByWeek page has the daily details of the SignOffs page.

On the List page of SignOffs, I'd like to have a hyperlink to the list page of QryByWeek where the Week and Campus have the same values on both pages.

If the details of SignOffs_list.asp could come up in a separate window that would be even more awesome.

Also, is there any way to make it so that once they have "signed off" on their entries by entering data for that week in SignOffs, they can't add/edit or delete and of that week's data in the original table that made QryByWeek (TimeCard)?

This is probably too much for one post. Sorry.

Thanks for all your help.

J
Jane 1/8/2007

Hi,
to open page in a new window modify your link in the HTML mode on the Visual Editor tab in the folowing way:

<A href="TableName_list.asp?{$row.1TableName_masterkeys}" target=_blank>TableName</A>


Unfortunately, you can't use complex foreign keys in ASPRunner.

ASPRunner do not support that.