[Solved] Form not saving the correct data
Posted: Thu Nov 09, 2017 8:59 pm
I have a form which saves data into a master table we'll call "Master List". There are three fields on this form, each are linked to other tables. These tables are similar in that they have an ID field and a text field. These four tables have their relationships set correctly.
In the form, when I'm entering data I can use the drop-down box and see all the text values "imported" from each related sub-table. My problem is when I select a value from one of these drop-down boxes and hit "Save Record" the drop-down boxes revert to "0" (numeric zero) and don't save the correct ID associated with the text I've just entered.
Sometimes when I'm moving from one drop-down box to the next, the entered value doesn't remain either. I can use the Next and Previous Record buttons to see other records - and for records which I've edited the correct information directly in the table, the correct ID number shows up in the drop-down. I just can't seem to get the values to save or update or something.
(I'd also prefer the drop-downs to show the related text instead of the ID's, but one problem at a time.)
In the form, when I'm entering data I can use the drop-down box and see all the text values "imported" from each related sub-table. My problem is when I select a value from one of these drop-down boxes and hit "Save Record" the drop-down boxes revert to "0" (numeric zero) and don't save the correct ID associated with the text I've just entered.
Sometimes when I'm moving from one drop-down box to the next, the entered value doesn't remain either. I can use the Next and Previous Record buttons to see other records - and for records which I've edited the correct information directly in the table, the correct ID number shows up in the drop-down. I just can't seem to get the values to save or update or something.
(I'd also prefer the drop-downs to show the related text instead of the ID's, but one problem at a time.)