I have a form that displays information on certain measurements for tools.
A new feature is being requested-
To add a command button that pops up a Comment form to add comments. The Comment form is associated with a table. On this form, if a note is made on a certain measurement, we want to have a flag on the form to indicate that that tool number has a note associated with it.
Sounds easy, but we can't add anymore fields to tool measurement form, so no yes /no, field etc.
Is there a way to do a search that somehow checks to see if a note was made on a particular record like say on an onCurrent event?