Hello Everyone,
I am pretty new to access so bear with me. I am helping a co-worker with an Access form we want to distribute to others.
In our form, we have two combo boxes that when a selection is chosen, it automatically fills another field out. For example, choosing your name in the "Employee Name" field automatically fills in the "Emp ID' field with your employee ID associated. Vice versa with the Part Number box to the PartDescription field.
The issue is that every other field (which for context is not auto-filled by anything) is populated to our chosen table (JobHours), except for the "Emp ID" and "Part Description" (Both of these are the auto-populated fields for the drop-down combo boxes). It fills into the form boxes fine, but does not flow to the table for whatever reason. Here are the relationships between these tables:
For added context, our database is split with the front-end forms populating data to a back-end stored elsewhere
If I am missing any important info about the tables and such, please let me know and I will provide them as needed. I'm pretty stumped as to why those two fields refuse to flow as needed, I'm hoping it is just a dumb/simple mistake right in front of my eyes.
I am pretty new to access so bear with me. I am helping a co-worker with an Access form we want to distribute to others.
In our form, we have two combo boxes that when a selection is chosen, it automatically fills another field out. For example, choosing your name in the "Employee Name" field automatically fills in the "Emp ID' field with your employee ID associated. Vice versa with the Part Number box to the PartDescription field.
The issue is that every other field (which for context is not auto-filled by anything) is populated to our chosen table (JobHours), except for the "Emp ID" and "Part Description" (Both of these are the auto-populated fields for the drop-down combo boxes). It fills into the form boxes fine, but does not flow to the table for whatever reason. Here are the relationships between these tables:
For added context, our database is split with the front-end forms populating data to a back-end stored elsewhere
If I am missing any important info about the tables and such, please let me know and I will provide them as needed. I'm pretty stumped as to why those two fields refuse to flow as needed, I'm hoping it is just a dumb/simple mistake right in front of my eyes.