I'm new with Access, so I need a little help with designing my access database.
I’d like to create a form where the user will have a dropdown for 2 fields (Size ID & Size Brkdn ID), another field will calculate Total Pcs based on the code selected on Size Brkdn ID.The Total Pcs will be used as part of another calculation.
When user chooses the Size ID = B and the corresponding SizeBrkdn ID = A, it should display on the form:
Size ID B S M L XL Total Pcs Size Brkdn ID A 1 2 2 1 6
Contents of each table
Size ID TABLE Size ID A S M L B S M L XL C S M L XL 2XL D S M L XL 2XL E S M L XL 2XL F XS S M L XL Size Brkdn ID TABLE Size Brkdn ID A 1 2 2 1 B 2 2 2 2 C 2 3 1 D 3 3 3 3 E 4 6 2 F 4 4 4 4 G 2 2 2 2 2