Ok, trying to figure out the best way to tackle this.
I have a child table in a set that stores user entered sizes.
Matrix_Id,16,0
Matrix,C,20,0
Dsize0,C,12,0
Dsize1,C,12,0
Dsize2,C,12,0
Dsize3,C,12,0
Dsize4,C,12,0
Dsize5,C,12,0
Dsize6,C,12,0
Dsize7,C,12,0
Dsize8,C,12,0
Dsize9,C,12,0
Dsize10,C,12,0
Dsize11,C,12,0
Dsize12,C,12,0
Dsize13,C,12,0
Dsize14,C,12,0
What I need to do is get the values of Dsize0 through Dsize14 plus the Matrix_ID to link it into another table that would have 15 records in it associated with the Matrix_ID that could then be used for a table drop down list to select from when entering data into fields in another table.
The selection table would have these fields.
Matrix_Id,16,0
Dsize,C,12,0
This selection table would need the records in it rewritten anytime the user selected a different Matrix to use.
I think I have an idea on how to do it so I am just bouncing the question around here to basically see if I will be going about this right.
On the invoice form there is a filed where the select which pricing matrix they use.
My thoughts are to use the On Change event to fire a script that would zap the table that would be used for drop down selection in other places on the invoice and then using a loop to write the data from the child table in the Matrix set to the selection table.
I have a child table in a set that stores user entered sizes.
Matrix_Id,16,0
Matrix,C,20,0
Dsize0,C,12,0
Dsize1,C,12,0
Dsize2,C,12,0
Dsize3,C,12,0
Dsize4,C,12,0
Dsize5,C,12,0
Dsize6,C,12,0
Dsize7,C,12,0
Dsize8,C,12,0
Dsize9,C,12,0
Dsize10,C,12,0
Dsize11,C,12,0
Dsize12,C,12,0
Dsize13,C,12,0
Dsize14,C,12,0
What I need to do is get the values of Dsize0 through Dsize14 plus the Matrix_ID to link it into another table that would have 15 records in it associated with the Matrix_ID that could then be used for a table drop down list to select from when entering data into fields in another table.
The selection table would have these fields.
Matrix_Id,16,0
Dsize,C,12,0
This selection table would need the records in it rewritten anytime the user selected a different Matrix to use.
I think I have an idea on how to do it so I am just bouncing the question around here to basically see if I will be going about this right.
On the invoice form there is a filed where the select which pricing matrix they use.
My thoughts are to use the On Change event to fire a script that would zap the table that would be used for drop down selection in other places on the invoice and then using a loop to write the data from the child table in the Matrix set to the selection table.
Comment