0

How can I count the number of records of a Table1 and insert this in a field of Table2

Helo

I am looking for a way to count  the number of records of a Table1 and insert this in a field of Table2

Thank you

2 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    If you want it in a "field" in Table 2.. but code behind a button.. If you want it to be dynamic.. put it in a formula field in Table2..  Basicaly.. 

    let t:= first(select Table2);

    t.Field := cnt(select Table1);

    (code not tested.. but you get the point)... This will put a count of Table1 records into the first record on table2. 

    • Ioannis
    • 5 yrs ago
    • Reported - view

    Got it Thanks

    Worked with small mod

    This is the final code

    let t := last(select '• version');
    let cnt := "Remedies-" + cnt(select 'KB-Remedies main') + " P-" + cnt(select trueHealth);
    t.(Count := cnt)

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1262Views