I thought htis would be fairly simple, there I go thinking again! Anyway, I have a field called "ETR" in a table called NEWETR1 (this is a string in the format 2003-0001)that i want to increment whenever a new ETR is opened, or in this case whenever this form is opened and then have...
I have somewhat of non-standard setup i would presume as this Maintenance DB is being updated from a flatfile DB. Basically, I have 2 tables one called tblETR and the other tblLOG. tblETR primary key is the ETR (Job) number with a one to one relationship to tblLOG.ETR.
WHat I need to do is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.