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 94
2 REPLIES 2

Steve
Platinum 4
Platinum 4

Meaning you want to prevent duplicate data? Or you want each user to be able to add only one row ever?

i want to when user add data in table qrcode
data to add following ref table from unit in project

when count data in qr code is full data can’t add

Top Labels in this Space