Im novice in Access but writting code in Java. I also know GW-Basic and cobol as non object-oriented languages. To better explain. I have a warehouse with textiles. Main form has a table with textile code. But each textile exists on several rolls(second table) that are on the subform each one with unique piece number which ofcourse is the second tables primary key. I need to input the roll number on a combo box on the main form and after update...

I have 2 tables with 1 to many relationship. First Table which is hosted on the main form of my database has records with products of some type and the second table which is in datasheet view in the subform has records with "pieces" of each product.
I want to make a combo box in the Main Form which will list and select the following 2 fields in a 2-column list. First column will have the ID field from the second table which is in...