Leo_Polla_Psemata
Registered User.
- Local time
- Today, 10:21
- Joined
- Mar 24, 2014
- Messages
- 364
MyCounter = Nz(DMax("MyCounter", "CustomerT")) + 1
Hi
With the above line on BeforeInsert event, we can create our own record counter.
For example "invoice number" on each invoice or "quotation number" for each sales offer we send to our cliants.
The problem is that then, our client, can see how many invoices or offers we have issued/sent.
Question
Could we make an increment number based on client account? Set up an increment number based on by new record per client.
For example
Company "ABC" will received quotation number "ABC_001" , for their first offer, "ABC_002" for their second
Company "DEF" will received quotation "DEF_001" , for their first offer, "DEF_002" for their second and so on...
1.ABC_001
2.DEF_001
3.DEF_002
4.ABC_002
5.GHI_001
Hi
With the above line on BeforeInsert event, we can create our own record counter.
For example "invoice number" on each invoice or "quotation number" for each sales offer we send to our cliants.
The problem is that then, our client, can see how many invoices or offers we have issued/sent.
Question
Could we make an increment number based on client account? Set up an increment number based on by new record per client.
For example
Company "ABC" will received quotation number "ABC_001" , for their first offer, "ABC_002" for their second
Company "DEF" will received quotation "DEF_001" , for their first offer, "DEF_002" for their second and so on...
1.ABC_001
2.DEF_001
3.DEF_002
4.ABC_002
5.GHI_001