AnsweredAssumed Answered

Relationship Question

Question asked by cpcnw on Jun 8, 2009
Latest reply on Jun 9, 2009 by philmodjunk


Relationship Question


Hi All,


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 !!!