i want to ask for my problem
i build data like this (in table project)
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?