making field searchable by modification date

[hafnerd]

i though i posted this yesterday, but seem to have been nuked. anyway, i have and inventory database. in the inventory there is a field (we will call "b") that is either blank or "yes". this is an auto entered field determined by another module called descriptions. so when something is entered in field "a" in descriptions, the field 'b' [in inventory modudle] is changed to "yes" in inventory.

here is the problem. i put in a modification date field in inventory. any changes to the data of that particular item and the date changes. but when descrtiptions updates the inventory as described above, the modification date does not change. i am confused. shouldn't the change from blank to "yes" in inventory module change the modification date?

how can i get it to do so?

[DonH]

You could brute force it by making a script that enters the date whenever data is sent from descriptions to inventory. Not sure if that is feasible with your layout or not.

[hafnerd]

the script in the field, in the inventory layout is as follows:

If(isEmpty(<File Missing>:<unknown>), " ", "Yes")

this tell the inventory that is field "a" in module descriptions is filled to change field "b" in inventory to a "yes". can i add on something to the script to make it searchable by modification of field "b" in inventory?

how do i "brute force" it?