Auto Filling Information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been trying to figure this out for the better part of a day.
I have a basic database I am creating that so far has 2 tables-1 for client
and contact info (name, business, addres, phone number, etc...) and it's
primary key is a client number that is assigned by the user.
The 2nd table is a 'Job Information' table for jobs that are
ordered-including job instructions, date due, invoice number, date invoiced,
paid, etc...
These 2 tables will be linked based on the Client Number, but the primary
key for the Jobs table is a Job Number that is an auto number.
I'm trying to create a form in which to enter the Job Information, however I
want to be able to enter the client number and have at just the client's name
and business name display...but I would like it to automatically pop up so
that this information is known but then the user can go on to enter in the
job information.
I've tried creating a sub form in a Job Info form based on the 1st table
with this information, but it doesn't find any of the records from the Client
Info table. I'm trying not to duplicate information on 2 tables, but rather
link them together with the Client Number.
Is there a way to do this that I'm just not seeing?
 
Do you have the LinkChild and Link Master properties of the subform set to
Client Number?
 
Yes, I they are set up for the ClientNumber to be the link. Those fields in
the properties box is Client Number.
Christina
PS I forgot to mention before that there will likely be more than 1 job per
client.
 
There are several ways. On the main form you could have a combo box to
display the ClientName (but bound to the client number). Use this as the
Master Link of the SubForm. The Child Link is also set to the Client Number.

Alternatively there is the concept of AutoLookup queries. This will allow
you to type in a customer ID on the main form and have teh relevant details
automatically completed. (and avoids the sub form). Have a look in the help
for "About AutoLookup queries that automatically fill in data"
 
Back
Top