I’ve created a table using the wizard which includes a date record. I’ve got the data entry form working as I’d like it to work except that I now realise that, because the user is required to record data only once per day, it would be useful to prevent the user from entering multiple records for the same date.
I’m assuming that by limiting the date field to be a unique value I can achieve my objective.
Is there any way to access or otherwise edit the SQL that libreoffice must generate even when the table has been created in wizard or design mode?
I’m working with LibO 22.214.171.124 if I remember correctly…