Despite having a dropdown for the students, I am unable to save the form entry due to a mismatch error. I have fiddled with the form’s pages section but still am getting this error
The issue here is that when you try to save the form, the Student’s Foreign Key does not match the primary keys. Did you create custom primary keys for your tables, or are you using the default ones generated by Five?
If you can send me the FDF of your application, I can have a look at it. You can email me directly at email@example.com
These are the steps for exporting an application in Five: Export and Import FDF Files | Five | Low-Code For Real Developers
I am using the default ones generated by five. I also have emailed you the file
The issue is that the primary keys in your Students Table are ID numbers, not the GUID primary keys typically generated by Five. For example, the primary key in your Students Table looks like this
Meanwhile, the primary keys for your Events Table are correct:
I assume that data was imported into the Students Table, including the primary keys, and this is likely causing the issue. To fix this, re-import the data, ensuring that primary keys are generated by Five, not imported. Also, be sure to check the box to replace all existing data
Let me know if this helps or not
OMG Thanks so much! It works!