Let’s say i have two table:
Table 1 is general settings and table two is invoice.
Table 1 has , company name, adress, invoice number first start, other documents number that will be pass to application table.
Table 2 its invoice table but the invoice number will be taken from general settings table becasue the invoice table will not be the same as id_invoice_table.
I need to pass the invoice number from general settings table 1 to the invoice number in table 2.
i need to set the invoice number in general settings table becasue it must be a custom number. When i will start the application i need to start with the last invoice number that i used on paper untill now when i start with application.