This content has been marked as final. Show 2 replies
Re #1, see:
Either number the jobs non-consecutively, or define a Jobs table with its own serial ID. Turning a project into a job would then require creating a related record in Jobs.
Roger that... will look into with your inputs. Thanks comment.