How to create two tables and join them, the users table and the second table for payments by SQLite "Inner join"?

Hello
How do I create a project that adds users to one table and adds their monthly payments to a second table? and How do I link or join the two tables using SQLite by “inner join”? How do I show each user with their monthly payments and confirm whether they paid or not?


test.flp (31.4 KB)

1 Like

test2.flp (36.7 KB)

1 Like

Thank you for the thorough explanation Mr. Vladimir_PV
This is beautiful
Please help me in the following cases:

1-In the users table, we add a date column and a cost column, and automatically every week, the cost and date are transferred to the payments table automatically or when a button is pressed for one user.

2-Is it possible to transfer the cost to the payment schedule for all users with the click of a button?

Thank you for the thorough explanation* Mr. Vladimir_PV
This is beautiful
Please help me in the following cases:

1-In the users table, we add a date column and a cost column, and automatically every week, the cost and date are transferred to the payments table automatically or when a button is pressed for one user.

2-Is it possible to transfer the cost to the payment schedule for all users with the click of a button?


test4.flp (38.7 KB)

To do this, you can implement an analogue of the repeat loop with countdown.
Also note that I created a new id for the user, this is necessary because the line number cannot be a user identifier, because the line number is not individual

Для этого можно реализовать аналог цикла repeat с обратным отчетом.
Так же обратите внимание, я создал новый id для пользователя, это нужно потому, что номер строки не может являться идентификатором пользователя, потому что номер строки не является индивидуальным

1 Like

Thank you for the beautiful explanation, and this indicates your extensive knowledge and broad horizons. Thank you again

  • If you have time to convert the files that you attached test.flp, test2.flp, test4.flp to pma format, because the flp format does not open for me, knowing that I have By updating the editor to version 2.5, and it gives me this message in the image:Flipabitv2.5

Conversion will not work, you need to use a new version of the program

Конвертировать не получиться, нужно использовать новую версию программы

Knowing that my editor version: Flipabit 2.5.0326 for flp format.

Knowing that the previous version : Flipabit 2.4.0706 for pma format.

The new version supports working with the old format.

1 Like

This is good.
I will update and try it.
Thank you very much, Mr. Vladimir_PV

Thank you , Mr. Vladimir_PV


Back to Flipabit >
Copyright © 2018. Flipabit Team. All rights reserved.