<div>
This may not be a required field on the FM side, but may require a value on the MySQL side. &nbsp;Check to see if the column in question will allow a null.
</div>


<div>
I checked on PhpMyAdmin and it says in the null column No.<br />
<br />
This is a complex shopping cart and I am hesitant to just change it because looking at the record there are lots more fields that are set to No too.<br />
<br />
Is there anything else that can be done?<br />

</div>


<div>
Once I said to revert back to the original for that record it allowed me to do what you suggested and now it isn't having that problem again.<br />
<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I have connected to the DB and have downloaded the table. &nbsp;I have modified the layout to delete the fields I don't need and saved it. &nbsp;When I go to modify the records I get the message that one of the fields I deleted is defined to require a value.<br />
<br />
This field isn't required on the shopping cart so how can I get FileMake to not require it?<br />
<br />

</div>
</div>


I have connected to the DB and have downloaded the table.  I have modified the layout to delete the fields I don't need and saved it.  When I go to modify the records I get the message that one of the fields I deleted is defined to require a value.

This field isn't required on the shopping cart so how can I get FileMake to not require it?



FileMaker Table From MySQL Problem

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

FileMaker Pro

Mac OS X is the desktop operating system from Apple Inc., found on Macintosh computers. OS X consists of a Mach/BSD-based kernel, operating system interfaces primarily based on FreeBSD and additional frameworks (written in C, C++ and Objective-C providing user interface and application-level services.