Hi,
I have a box (record) called 'invoicenumber'. I want it to show: 'aaa.bb.cc'
aaa(a number)= it start at 1 and add up everytime a new order is made
bb(a number)= it shows the KlantId(CustomerId)
cc(a number)= it start at 1 and add up everytime the same customer is chosen.So when the number is 3 it means that it is the third time that the specific customer made an order
Example:
the form look like this (like the order form from Northwind:
Mainform
--------------------------------------------
Bill to: [KlantID](name) Ship to: [Shipname]
Address Address
[OrderID] [Invoicenumber]
Subform
----------------------------------------------
Productname Quantity Price Total
-----------------------------------------------
So the invoice should look like this the first time
invoicenumber:001.01.01
I hope that i explained it wel
THX IN ADVANCE
Dan
I have a box (record) called 'invoicenumber'. I want it to show: 'aaa.bb.cc'
aaa(a number)= it start at 1 and add up everytime a new order is made
bb(a number)= it shows the KlantId(CustomerId)
cc(a number)= it start at 1 and add up everytime the same customer is chosen.So when the number is 3 it means that it is the third time that the specific customer made an order
Example:
the form look like this (like the order form from Northwind:
Mainform
--------------------------------------------
Bill to: [KlantID](name) Ship to: [Shipname]
Address Address
[OrderID] [Invoicenumber]
Subform
----------------------------------------------
Productname Quantity Price Total
-----------------------------------------------
So the invoice should look like this the first time
invoicenumber:001.01.01
I hope that i explained it wel
THX IN ADVANCE
Dan