The documentation for Query by Attribute discusses at length how a # query performs with or without the Map NULL values to blank values checked.
I do not see this checkbox in the field Explorer window for an Object field. Am I missing something here? It is there for other types of fields but not Object fields. I have added an object field to an existing table. When added the field is undefined. At some point I will need to query the using Query By Attribute on this field? QUERY BY ATTRIBUTE([Judges];[Judges]DivRestrictions_1JR_2SR_3Both;"division";#;0) All the records in the table will be returned I am assuming because the field is undefined for all the records. I am assuming that I am going to have to prime the records with an object containing “division" = 0. I thought perhaps the NULL mapping setting might help me out here, but I do not see anyway to change the mapping option for testing. John John Baughman Kailua, Hawaii (808) 262-0328 john...@hawaii.rr.com ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************