C
CP
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?
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?