I have a table containing fields ID, Date, Amount, Payments say first
row has0001, 1-Feb-2024, 100000, 10000in next row user will input only
last field (Payments)unique ID works well for ID field today() also
works finewhat i want is 90000 in Amount ...