Hello.
I have a table called Job. In this table I have Job_No with is set to auto increnement.
I need to make a new table called contract. It will be a child table to Job and will be linked by Job_No
On the table contract I need to set it to assign a new number for every record against the the same Job_No.
So to sum up.
Job.Job_No = 1021294
I add a new contract, I need this to show Contact.Contract_No = 1
If I add another new contract to the same Job.Job_No I need this to show 2
When I view the first Contract, it will show 1021294/1
The second contact will show 1021294/2
The next job I add will have a Job_No of 1021295
I add a new contract, I need this to show Contact.Contract_No = 1
If I add another new contract to the same Job.Job_No I need this to show 2
When I view the first Contract, it will show 1021295/1
The second contact will show 1021295/2
Is this possible. I can set mt Contract.Cintract_No to Auto Increment but it will keep going on and on.
Thanks
Paul