Can a New Record trigger?

Support
1

Hi
When I enter new record on the sub table, I want to update one field in main table.

Main table field called Tested : default answer “no”
When a new record on the on sub table it need to trigger Tested vale to “yes”.

Help me please.
Thanks
Mark

2

Hi,

I would suggest something like the following, if I understand what you are trying to do:

  • Under the Subtable have a new field RecCount that does a count of records COUNT({COL HEADER})
  • Then Tested can have a simple formula to check if RecCount is more than ‘yes’

I hope this makes sense.

1 Like
3

Thanks.
Another question please.

Does COUNT() work only subtable?
How to count number of records in the Main table?

Thanks & Regards
Mark

4

Hi,

Click on the place marked below and you’ll have the option to count the records:
圖片