AnsweredAssumed Answered

Generate Serial Number from list based on field data

Question asked by MaherQ on Dec 10, 2014
Latest reply on Dec 16, 2014 by MaherQ

Title

Generate Serial Number from list based on field data

Post

hi , if someone may help me i will be grateful for him

i have table for submit new customer with field salesman name 

and i have table for new customer ID based on city ( data all enterd for every city new Customer ID Serial Number)

Salesman table include his city

what i want is if the salesman create new customer , the Customer ID will take the next Serial from the Customer ID table based on the salesman city 

Ex. of Customer ID table

CustomerID             City

2000                        Den

2001                        Den

3000                        WC

3001                        WC

and so on

 

is this possible to do and if yes how can i make it

thank you in advance 

M.Q

Outcomes