You only need one main table. Include the date of receipt, amount, payee, table, etc. ...

Then do a few tables, such as table table, operator table.

This way you can use the combo control in the cash register form. Add the tables and operators. You can directly select the table number and who operated it.

From your main function. You make a form, use listview to display all the collection data. Make a query that can be queried by date, payee, table, etc. and then display it in this litview. Then display it in this litview.

You want to do historical billing queries, using SQL. For example, you want to query the billing between two dates, using the SQL statement

sql = "select * form main table where collection date between the first date and the last date"

You can look at someone else's source code for a program / showhtml/3914.htm

There's a lot more like it at this site.