How to auto calculate the available vacant slot

  • Thread starter Thread starter Zetsubo69
  • Start date Start date
Z

Zetsubo69

Guest
Good day,

I have a simple registration program where a person will register under 1 table, each table have 10 empty vacant slot.

I would like to know on the logic for both vb.net and SQL on how to achieve the result.

Example.

1547462.png

As there is 2 person register under table 2, the vacant slot should be 8 left.

When i register another person under table 2, the vacant slot will be 7 left.

Continue reading...
 
Back
Top