Hello All,
I’m a script-case newbie, I come from an environment where I programmed in only VBA, with access, outlook, excel, etc. I have been messing around with script-case 8.1 for a couple of days, and i’m able to link to my database, and create some simple forms. I just need a little primer to get me in the right direction in regards to passing parameters or variables to another control (Or getting parameters from another control). In VBA i’ve always been able to create my listboxes, combo boxes using vba and setting the row source this way. Either by creating the string for the row source or creating the filter on the fly. I can see that using script-case is not the same or maybe it is, i just don’t have the knowledge yet.
So here is what i have, very simple and basic. I have a control that has a list of customers, when user selects one of these customers i want the another control (Jobs) to list only the jobs that are for that customer. How do i get the Jobs control to grab the customerID from the customers control and then filter the list. Or how do i pass the sql string to the jobs control with the customerID filter.
Thanks everyone, I’m sure i’ll be posting more questions.