mtkalman
09-29-2017, 06:34 AM
Hello there!
Im new to access, and faced the following problem.
At my workplace we have a product assembly with loads of component variations.
I created a table for the components list, and gave them a yes/no variant, to decide if they are sandardised parts or not.
On the assembly level, where i have 3 components at a time, im refering to that tables related yes/no value, to decide, if all the components are standad, therefore
the assembly is standard.
The lis of componenets is called as PartList. So for each component, i added the PartList table separetly, and set upt the connection, as on the picture.
After that, i made a sheet, and put 3 inputboxes on it for the standard values.
And the problem is, no matter what i do, every time, im trying to get the PartList_2 value, the inputbox just changes it to PartList_1 as soon as i save, or exit planning view.
How can i fix this?
20520
Im new to access, and faced the following problem.
At my workplace we have a product assembly with loads of component variations.
I created a table for the components list, and gave them a yes/no variant, to decide if they are sandardised parts or not.
On the assembly level, where i have 3 components at a time, im refering to that tables related yes/no value, to decide, if all the components are standad, therefore
the assembly is standard.
The lis of componenets is called as PartList. So for each component, i added the PartList table separetly, and set upt the connection, as on the picture.
After that, i made a sheet, and put 3 inputboxes on it for the standard values.
And the problem is, no matter what i do, every time, im trying to get the PartList_2 value, the inputbox just changes it to PartList_1 as soon as i save, or exit planning view.
How can i fix this?
20520