Counting records

[qwerty`]

i have 2 tables, tableA (aID, Name) and tableB (aID, bID, status). aID in tableB reference to the one in tableA. i have a layout based on tableA. On that layout, i want to diplay the total number of records that each ID has in tableB which has a status of "Approved".

If using SQL, it will be:

Select Count(bID) FROM tableA a, tableB b

WHERE a.aID = b.aID

AND b.status = "Approved"

AND a.aID = 1

but how do i go about doing this without using SQL?

[dbruggmann]

I'm not sure, if it is the most efficient way, but I would do the following:

1) Create in table A a new global field

[qwerty`]

that seems to work.. thanks!