It is made of 2 tables and a query and a form
The sql is as follow:
SELECT Client1.TableID, Sum(NZ(Client1.Seat,0)) AS USeat, (NZ([Tables Event 1].Seats,0)-Sum(NZ(Client1.Seat,0))) AS VSeat, [Tables Event 1].Seats, IIf([Reserved]="YES","R",IIf([VSeat]=0,"F",IIf([USeat]=0,"V",IIf([VSeat]>0,"P","?")))) AS Status
FROM [Tables Event 1] INNER JOIN Client1 ON [Tables Event 1].ID=Client1.TableID
GROUP BY Client1.TableID, [Tables Event 1].Seats, [TablesEvent1 Extended].USeat, [Tables Event 1].Reserved;
In the forms the control source of the field Status is as follow: =DLookUp("[Status]","[TablesEvent1 Extended]","[TableID]=[Form]![ID]")
what I am missing here?