Users can view the Program from Datapage1 (see image) and create an association into ProgramtoSiteAssociation table using Datapage2 (see image) that offers a list of Sites from the Site Table and receives the Program ID from the Program table. If the Program Status (Program Table, Datapage1) is moved to Inactive, I do not want the user to be able to use Datapage2 and create a new recrod in the ProgramtoSiteAssociation table.
Is there a way to disable Datapage2 based on the Program table or create a pop-up that tells the user they cannot make an association due to the Program being inactive.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
wimtracking2
I have 3 table:
1. Programs
2. Sites
3. ProgramtoSiteAssociation
Users can view the Program from Datapage1 (see image) and create an association into ProgramtoSiteAssociation table using Datapage2 (see image) that offers a list of Sites from the Site Table and receives the Program ID from the Program table. If the Program Status (Program Table, Datapage1) is moved to Inactive, I do not want the user to be able to use Datapage2 and create a new recrod in the ProgramtoSiteAssociation table.
Is there a way to disable Datapage2 based on the Program table or create a pop-up that tells the user they cannot make an association due to the Program being inactive.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.