I have started a DB with two forms. One has CustNum the other has TxNum.
I need TxNum to be in the form CustNum-SerialNum that is the transaction number auto generated and added on to the customer number with a hyphen inbetween (say: 1234-009 that is customer No 1234's ninth transaction)
I want it so that when a record is commited, whatever the CustNum is, new data is entered into the TxNum.
How do I even make a start setting this up. I cant even get CustNum to write into TxNum without modification even though I used the relationship graph?
Any pointers / step tutorial links appreciated !!!