I am a database beginner! I have set up a master detail form in mysql with a delphi form front end. When I come to update the master form all is well, when I come to update the detail form I get an error telling me the key field has no value.
Question: Should the detail form have an auto increment key field, if not how do I get to give the record the 'next' number.
Ken
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am a database beginner! I have set up a master detail form in mysql with a delphi form front end. When I come to update the master form all is well, when I come to update the detail form I get an error telling me the key field has no value.
Question: Should the detail form have an auto increment key field, if not how do I get to give the record the 'next' number.
Ken