AnsweredAssumed Answered

Relationship Question

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

Title

Relationship Question

Post

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

Outcomes