D
Datameister
I am working with and existing table (Table1) with 11,000 records of parts,
their specifications, and other information. The table includes about 60
fields. My goal is to create a form which, after selecting a "part number",
automatically fills in about 5 of the fields (specifications) which are
static, and then allow the remaining fields to be manually filled. There
are many "orders" for unique "part numbers".
I've created a "Parts Table" with "Part number" as the primary key. I then
attempted to create a form using a combo box to propagate the specifications
in text boxes, and more textboxes for the remaining fields for Table1. It
works nicely except that the 5 specification fields are not completed in
Table1. The primary key in Table1 is "ID" (autonumber).
I need help with the design of my form to make it function correctly. I
have a one-to-many (part number-to-part number) relationship in place between
the two tables. I've tried various methods, including queries, to no avail.
I am not very experienced using code or events.
In addition, I have an alphabetical "Lab Code" field which I want to
automatically generate the code. Such as Record 1:ABCD, Record 2:ABCE, Record
3:ABCF, etc.
Thanks in advance for help with any or all of this.
their specifications, and other information. The table includes about 60
fields. My goal is to create a form which, after selecting a "part number",
automatically fills in about 5 of the fields (specifications) which are
static, and then allow the remaining fields to be manually filled. There
are many "orders" for unique "part numbers".
I've created a "Parts Table" with "Part number" as the primary key. I then
attempted to create a form using a combo box to propagate the specifications
in text boxes, and more textboxes for the remaining fields for Table1. It
works nicely except that the 5 specification fields are not completed in
Table1. The primary key in Table1 is "ID" (autonumber).
I need help with the design of my form to make it function correctly. I
have a one-to-many (part number-to-part number) relationship in place between
the two tables. I've tried various methods, including queries, to no avail.
I am not very experienced using code or events.
In addition, I have an alphabetical "Lab Code" field which I want to
automatically generate the code. Such as Record 1:ABCD, Record 2:ABCE, Record
3:ABCF, etc.
Thanks in advance for help with any or all of this.