Only add data with ref table

hy guys,
i want to ask for my problem
i build data like this (in table project)
3X_d_6_d6ed86fd9ef74cb1102acf9e47d563c525f357a2.png
and this my view


I want to make when the user adds data (in another table / table “qrcode”) then the data added is no more than the data written in the project table

max only like in project

i use this formula, but its not work

if ( 
ANY(SELECT(project[unit], (ISNOTBLANK("project[idproject]"))))
<= 
COUNT( SELECT( QR CODE[keterangan], ([idproject] = [idproject]))),
ADDS_ONLY,
READ_ONLY
)

can you help me?

0 2 96
2 REPLIES 2
Top Labels in this Space