DaniBoy
Registered User.
- Local time
- Today, 21:32
- Joined
- Nov 18, 2001
- Messages
- 174
Hello,
I am making a simple 2 table database for a client. Its only a Customer Table and a Workorder Table. Here is my problem:
There is a text field called "Job_Num" on the Customer's table that never changes, The client wanted to have the workorder number to be the "Job_Number + the Workorder Number" Ex: 0152-1. So what I created was a field that had "=[Job_number] & "-" [WOid]". This gave me what ever the job number plus the work order number.
I showed him the program and what he wants is the following:
He wants the workorder number to be continues depending on the job number. In other words, if he picks job number 152 and is the first time they do a workorder on it, the WO# should be 152-1 but once he picks the same job number in the future it should go to 152-2 and so on.
Basicly this way he can tell how many work orders his done to that job number by just looking at the last diget on the WO#.
Any susgestions on how to do this?
Thank you,
DaniBoy
I am making a simple 2 table database for a client. Its only a Customer Table and a Workorder Table. Here is my problem:
There is a text field called "Job_Num" on the Customer's table that never changes, The client wanted to have the workorder number to be the "Job_Number + the Workorder Number" Ex: 0152-1. So what I created was a field that had "=[Job_number] & "-" [WOid]". This gave me what ever the job number plus the work order number.
I showed him the program and what he wants is the following:
He wants the workorder number to be continues depending on the job number. In other words, if he picks job number 152 and is the first time they do a workorder on it, the WO# should be 152-1 but once he picks the same job number in the future it should go to 152-2 and so on.
Basicly this way he can tell how many work orders his done to that job number by just looking at the last diget on the WO#.
Any susgestions on how to do this?
Thank you,
DaniBoy
Last edited:
