<div>
When you designate a field as &quot;Required&quot;, FileMaker will check to see that the field has a value whenever you commit the record. This occurs when you modify any field on that record, such as your BldgNotes field. it sounds like someone retroactively made one or more of the fields &quot;required&quot; without first checking to see if those fields had values in them.<br />
<br />
You have four options: You can go into the Manage Database screen (assuming you have permission to do this) and remove the &quot;Required&quot; attribute (which you'll find on the &quot;Verification&quot; tab in the Field Options sheet); you can leave the &quot;Required&quot; attribute checked but also check the &quot;Allow user to override warnings&quot; box; or you can give the fields values, either from the user interface or from a script. If the fields really should be required (the person who set that property presumably had a good reason to do so), then you'll either have to put those fields on some layout, somewhere, so you can assign values to them, or you'll have to write a script to assign these fields some sensible values. Here's a sample script to do this:<br />

<pre><code class="code-10 nolinks" id="code-20-41507403-1"><span>Show all records</span>
<span>Go to Record/Request/Page [first]</span>
<span>Loop</span>
<span>  If ( IsEmpty( Required_Field_1 )</span>
<span>    Set Field [Required_Field_1; &lt;some sensible value&gt;]</span>
<span>  End If</span>
<span>  If ( IsEmpty( Required_Field_2 )</span>
<span>    Set Field [Required_Field_2; &lt;some sensible value&gt;]</span>
<span>  End If</span>
<span>  If ( IsEmpty( Required_Field_3 )</span>
<span>    Set Field [Required_Field_3; &lt;some sensible value&gt;]</span>
<span>  End If</span>
<span>  Go to Record/Request/Page [next; exit after last]</span>
<span>End Loop</span>
</code></pre>
<br />
As I said, the other option is to put those fields on some layout somewhere so you can give them values manually. This is the best way if you don't have many records and you can't reasonably determine &quot;&lt;some sensible value&gt;&quot; programmatically. First, check to see that those fields aren't already on some layout: after all, if their values are required, there must be some way of giving them values! If it's necessary or convenient, you can put them on the tab panel you described, or you can put them on a special layout. I always have a &quot;Maintenance&quot; layout for every table in my database. I give it the same name as the table, but precede the name with an underscore (so you might have a &quot;_Cataloging&quot; layout). This layout doesn't have to be pretty, but it DOES have to have every field defined in that table on it. That way, you can always go to this layout to make &quot;back door&quot; changes when necessary. By the way, I collect all the &quot;maintenance&quot; layouts together and put them in a &quot;Maintenance&quot; folder in the Layout Manager, then use the Privileges mechanism to make sure normal users don't have access to those layouts.
</div>


<div>
Thank you. The 3 fields are necessary in other layouts as is.<br />
I will have to add them to the new layout with a change in value list.<br />
<br />
I wasn't think about all fields being &nbsp;in each record in a table. (flat file mentality)
</div>


<div>
<div class="content wysiwyg-content">
I have two tables (Buildings and Cataloging) that are related and over several layouts/tabs everything is working as it should.<br />
I created a new field (BldgNotes) in the Cataloging table, plain text, no options.<br />
There are three fields in the table that are &quot;Required Value&quot;<br />
When I add data to the new field which is on a tab all by itself it calls for data in each of the three fields with the &quot;Required Value&quot;.<br />
What is the link that is forcing this? Can I stop it or should I just add the &quot;Required Value&quot; fields to the new layout tab?
</div>
</div>


I have two tables (Buildings and Cataloging) that are related and over several layouts/tabs everything is working as it should.
I created a new field (BldgNotes) in the Cataloging table, plain text, no options.
There are three fields in the table that are "Required Value"
When I add data to the new field which is on a tab all by itself it calls for data in each of the three fields with the "Required Value".
What is the link that is forcing this? Can I stop it or should I just add the "Required Value" fields to the new layout tab?

FileMakerPro10 required fields interfering with data entry.

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.