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.