Orders numeration (Serial)
i'm afraid that my question was here already, but it is very hard to find it. Please don't be angry with me.
I have made a DB with following tables: customers, contracts, orders.
Every customer has it's unique number as well as contract, but as for the orders - i run them in single table, but I want them to have serials linked with contract number (to be independent), for example:
contract #1, order 1, 2, 3, 4
contract #2, order 1, 2, 3, 4
As far as I see it - there must be related table to my contract like [orders.serial] with only ID and SERIAL fields.
Is it possible to do it without using scripts? i doubt it. But what could be the most convinient way of running this script? I would like to avoid buttons.
Thank you for all your suggestions!