I have a job table where I need to have a project number field update automatically on a form.
The format is "03-023" where '03' is the year (can be sourced from the creation date). And '023' is the current project number for that year. I would like the project number to automatically...
I'm fairly new to access but have a little bit of database experience in the past. Basically I have two tables.
Job table (includes job number, title etc.)
Client table (includes name, address, details etc)
A job can only have one client so it is a one to many relationship. However sometimes...
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.