AnsweredAssumed Answered

Orders numeration (Serial)

Question asked by AntonChuykin on Jun 23, 2012
Latest reply on Jul 2, 2012 by philmodjunk

Title

Orders numeration (Serial)

Post

Dear Friends,

  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! 

Outcomes