display name and address in a form

M

Maria

i have a table named "Customers" with the name of the customer and the
address and an other table called "Calls" used to record all the calls and
problems the customers have.
this table is filled using a form which needs to be printed afterwards. i
need to select a customer and that its address appeared in the form "calls".
how can i do that?
 
J

Jeff Boyce

Maria

Instead of printing the form, consider using a query to return the rows you
want, then basing a report on the query.

If you join the customer name info to the calls in your query, you can use
the report's "grouping" to show a customer in a group header, and all
related calls in the details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top