B
Ben Johnson
I have a master data entry form based on a query that
collects info from 5 different tables. Essentially, the
user needs to be able to enter info about:
1. Clients
2. Job Addresses
3. Real Estate Agents
4. Type of Job
5. Client's Solicitor
All of this info is in separate tables, hence the query to
pull it all together for the master data entry form.
I've just discovered that the user can enter all of these
types of information only into a brand new record! I mean,
if they enter only info about Clients/Job Address/Agent and
then come back later and attempt to add in Solicitor
details the query won't let them (at least I think it's the
query).
The relationships are such that Client/Job Address/Job Type
MUST be in all records and all other info is optional - but
I need to make it so that the other info can be added in at
a later time if the user wishes.
In essence, once the record has been committed (ie. the new
record button is clicked, or the record is closed) then the
user cannot add Agent or Solicitor information in at a
later time. This is not an acceptable situation.
I spent hours on the form design so I'm really hoping I
don't need to make any radical changes to make it work.
Any help appreciated.
Oh, the query that is the basis for the master data entry
form is a simple select query that grabs all fields (*)
from each table.
Kind regards,
Ben Johnson
collects info from 5 different tables. Essentially, the
user needs to be able to enter info about:
1. Clients
2. Job Addresses
3. Real Estate Agents
4. Type of Job
5. Client's Solicitor
All of this info is in separate tables, hence the query to
pull it all together for the master data entry form.
I've just discovered that the user can enter all of these
types of information only into a brand new record! I mean,
if they enter only info about Clients/Job Address/Agent and
then come back later and attempt to add in Solicitor
details the query won't let them (at least I think it's the
query).
The relationships are such that Client/Job Address/Job Type
MUST be in all records and all other info is optional - but
I need to make it so that the other info can be added in at
a later time if the user wishes.
In essence, once the record has been committed (ie. the new
record button is clicked, or the record is closed) then the
user cannot add Agent or Solicitor information in at a
later time. This is not an acceptable situation.
I spent hours on the form design so I'm really hoping I
don't need to make any radical changes to make it work.
Any help appreciated.
Oh, the query that is the basis for the master data entry
form is a simple select query that grabs all fields (*)
from each table.
Kind regards,
Ben Johnson