G
Guest
Hi there, this is probably a beginner question...
I have two types of projects (Projects and Service Contracts). And I want to
have a sequential index number for each of them that is seperate from the Key
index.
So we get:
Index SC's Proj's
1 1
2 2
3 1
4 3
5 2
etc...
I figure there's two ways I can have this work. Do a count of all the
records in the project table that have Is_Service_Contr set to YES. Add 1 to
that and stick it in the Service_Contr_Num for the new entry. My count query
works fine but when I try to refer to it from within a form control I get an
error msg in the control: "#Name?"
Anyone know what I'm doing wrong here?
The other way I thought of was to query for the previous highest value, +1
it and use it as the new ID. I don't really know the sql or vb code for that.
If anyone could help me out or suggest a real solution that'd be great.
cheers
Nick
I have two types of projects (Projects and Service Contracts). And I want to
have a sequential index number for each of them that is seperate from the Key
index.
So we get:
Index SC's Proj's
1 1
2 2
3 1
4 3
5 2
etc...
I figure there's two ways I can have this work. Do a count of all the
records in the project table that have Is_Service_Contr set to YES. Add 1 to
that and stick it in the Service_Contr_Num for the new entry. My count query
works fine but when I try to refer to it from within a form control I get an
error msg in the control: "#Name?"
Anyone know what I'm doing wrong here?
The other way I thought of was to query for the previous highest value, +1
it and use it as the new ID. I don't really know the sql or vb code for that.
If anyone could help me out or suggest a real solution that'd be great.
cheers
Nick