I have 2 forms, 2 tables - one where user submits creative, and they're done then the other where they submit reimbursement for a previously submitted creative. Since they can only submit reimbursement for a creative submission they've already submitted, I am using a cascading dropdown based on submission type (Advertising or Sales Contest) which is the same in the creative table/form. They have to choose submission type then a name, start and end date in the creative form. So for this reimbursement form, I have a cascading dropdown looking up the creative table via user unique id, and then based on submission type cascading dropdown, I have them go to the next cascading dropdown which shows the available previous submissions under that category.
My question is, when they select the creative, I have a unique id for each creative submission in the other table/form that is an autonumber, is there any way for me to pass that unique creative id from that table into somewhere in the reimbursement form/table so that the reimbursement would be tied to the creative submission they previously did?
Please help! (Must figure this out sooner rather than later - I'm in a jam)
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
brbbrid
I have 2 forms, 2 tables - one where user submits creative, and they're done then the other where they submit reimbursement for a previously submitted creative. Since they can only submit reimbursement for a creative submission they've already submitted, I am using a cascading dropdown based on submission type (Advertising or Sales Contest) which is the same in the creative table/form. They have to choose submission type then a name, start and end date in the creative form. So for this reimbursement form, I have a cascading dropdown looking up the creative table via user unique id, and then based on submission type cascading dropdown, I have them go to the next cascading dropdown which shows the available previous submissions under that category.
My question is, when they select the creative, I have a unique id for each creative submission in the other table/form that is an autonumber, is there any way for me to pass that unique creative id from that table into somewhere in the reimbursement form/table so that the reimbursement would be tied to the creative submission they previously did?
Please help! (Must figure this out sooner rather than later - I'm in a jam)
Link to comment
Share on other sites
5 answers 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.