Hi All,
I need help with form/tables. I want to know how to create automatic rows in a table based on form.
I have two tables 1-reference table (with fields part number,operation, dimension) and 2- data entry table (part number, operation, dimension, and dimension's value) and I have a form with two drop down boxes. So, When A User selects a part number and operation from drop down list, a query can go and look the related dimensions in refernce table and create those fields in data entry table and shows them on the form with part number,operation and dimension fields already filled and a blank column for entering value of the dimension.
Thanks in advance.
I need help with form/tables. I want to know how to create automatic rows in a table based on form.
I have two tables 1-reference table (with fields part number,operation, dimension) and 2- data entry table (part number, operation, dimension, and dimension's value) and I have a form with two drop down boxes. So, When A User selects a part number and operation from drop down list, a query can go and look the related dimensions in refernce table and create those fields in data entry table and shows them on the form with part number,operation and dimension fields already filled and a blank column for entering value of the dimension.
Thanks in advance.
