I am creating a data driven test. I have 2 pages: Login.aspx & Calculation.aspx
Login page will take the UserID & Pwd from database tables and after successful authentication it will redirect to Calculation.aspx. Now Calculation.aspx have 4 textboxes whose values suppose to fill from database datasource.
In database I have 2 tables, one(lets say Users) for User IDs/Pwd(lets suppose 3 rows) and the other one(lets say MyInput) is for the input values(lets 5 rows) for Calculation.aspx.
My requirement is that Test Studio suppose to loop through all the 3 user id(of Users table) and for each iteration it suppose to run 5 iterations(of MyInput table) on Calculations.aspx, which means it should take first userid/pwd from Users table and complete 5 iterations for all 5 values of MyInput table then take 2nd pair of userid/pwd values from Users table, complete same 5 iterations for all 5 values of MyInput table and so on.
My question is how can I incorporate 2 tables in a single aii file with multiple outer/inner or sub-iterations?