S
Samantha Penhale
Hello,
I've got a primary table connected to 2 many-to-many tables, and each of
those has two lookup tables apiece. The M2M tables associate the M2M
relationship between each set of lookup tables. For each M2M table, I then
need to store a resultant entry id from the M2M table on my primary table to
represent a selected combination. I have combo fields on my form, and those
fields set the id fields as selections are made. The id fields are bound to
the primary table. The values in the id fields are not storing on the primary
table. The values selected by the user are storing correctly. I do not know
what I am doing wrong.
Primary table: TBL_DATASHEET_INVENTORY
Primary form: frm_DatasheetInventory
M2M Tables: M2M_SECTIONS_LOCATIONS
M2M_CHEMICALS_MANUFACTURERS
LookupTables: LKUP_SECTIONS
LKUP_LOCATIONS
LKUP_CHEMICALS
LKUP_MANUFACTURERS
Ultimately, I'm attempting to store a record with a combination of a
chemical, it's manufacturer, section, location, and the sectionlocation_id.
The sectionlocation_id is a combination of section and location, with many
rows associated with it...in other words, a section might be "Sign &
Graphics", and there would be many locations associated. The user will choose
a Location, "Trucks" and then there will be one or many rows associated with
that combination. So, in the end I need to store 5 ids with this particular
row so that I can display the combination later.
I've got a primary table connected to 2 many-to-many tables, and each of
those has two lookup tables apiece. The M2M tables associate the M2M
relationship between each set of lookup tables. For each M2M table, I then
need to store a resultant entry id from the M2M table on my primary table to
represent a selected combination. I have combo fields on my form, and those
fields set the id fields as selections are made. The id fields are bound to
the primary table. The values in the id fields are not storing on the primary
table. The values selected by the user are storing correctly. I do not know
what I am doing wrong.
Primary table: TBL_DATASHEET_INVENTORY
Primary form: frm_DatasheetInventory
M2M Tables: M2M_SECTIONS_LOCATIONS
M2M_CHEMICALS_MANUFACTURERS
LookupTables: LKUP_SECTIONS
LKUP_LOCATIONS
LKUP_CHEMICALS
LKUP_MANUFACTURERS
Ultimately, I'm attempting to store a record with a combination of a
chemical, it's manufacturer, section, location, and the sectionlocation_id.
The sectionlocation_id is a combination of section and location, with many
rows associated with it...in other words, a section might be "Sign &
Graphics", and there would be many locations associated. The user will choose
a Location, "Trucks" and then there will be one or many rows associated with
that combination. So, in the end I need to store 5 ids with this particular
row so that I can display the combination later.