This is probably very simple and I have overcomplicated things
I have a form which uses a combo box to pull data from my client database
where once found there details appear on the form which is actually a new
quote/job

 ClientID / Name / Address
 JobID / ClientID / Job data

ClientID being related.  On the form for Jobs I use a combo box to pull in
the details of the customer uses ClientID

The problem is that I may start a new job unaware that the client does not
exist, then obviously it puts up an error message.  I would like the ability
to enter a new client using the same form, therefore:

If I enter a new client it gives a blank job with no client data
I then enter both client and job data at the same time uses the open form
It then autoupdates the client table and adds the new job in the job table

Any help gratefully received?