Creating forms based on two tables, and partial populating with query

[Guest_imported]

We have two different tables (Client) and (JobList)
We are trying to create a form to enter new jobs (ie new records for (Joblist) and have a query to populate fields from (Client)

Basically the form looks like this

Job Number
Job Name
Job Address
Client Name
Client Address

We want to have the client portion of the record to be automatically filled in if the client is a repeat (hence a query for that information). However, when we run the query to prompt for client name and just import the address, into a form that has the job info we get no records popping up. How can we create a query/form system that allows partial population of a form based on a seperate table, and then allows you to enter in the other data manually?

Thanks for any help

Ray

 

[kpalazzi]

You can base the form on a query.
1. First, you must create a lookup field in the joblist table to lookup customer name from the customer table.

2. Create a new query using joblist and customer table. Create the relationship (if it doesn't already exist) by clicking on the Customer field in joblist table and dragging to the customerid field of customer table.

3. Include in the query the joblist fields and the fields from the customer table that you want to prefill. **You don't need the customer name since it is already included in the joblist table.

4. Base your form on this query, and when you choose the customer name from the list, it will fillin all the fields you included from the customer table.

**(if you need to enter new records thru this form as well, make sure the "limit to list" property on the customer lookup field in the joblist table is set to "no".


Kimberly Palazzi
kpal29@hotmail.com