Remove a deleted row for Form

[FeedTheChunk]

I removed a column, foreign key, from my database, MaraiDB 10, using phpMyAdmin. The foreign key was not used being used. However the Form still knows about the column. I can see this by going to the form properties → Data → Filter. When I show the Field Names in the Criteria window the removed column is still there.

Now when I save the record I get the following error message from the database:

[ma-3.1.9][10.3.21-MariaDB]Unknown column ‘transaction_id_fk’ in 'field list’

The form was originally created from the Form Wizard. Is there some way of removing that old column so the form no longer knows about the column that was removed from the table? The only way so far that I’ve found is to create a new form.

Thanks

[Ratslinger]

Hello,

Based upon the image displayed, the column is either not deleted from the table, the delete has not been committed or the Base file was open when doing this and you need to close and re-open (or close form and refresh tables - in table section of main form from menu View->Refresh tables). You can delete this column from Base. Just edit the table.

As with all questions, if this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.

[FeedTheChunk]

The Base file was open when deleting the column from the db in phpMyAdmin. Reloading Base seems to have solved the problem. Lesson learned. Thank you for your time.