View Full Version : Pulling related value for report?


Ramma2
08-26-2002, 01:03 PM
Hello all!

So I'm trying to setup a report, and having some trouble.

In a form, the user selects a customer from the Customer table, along with delivery times. This information then goes to the Schedule Details report.

The report then displays the customer, along with the times. What I want to do is display the city for that customer as well, in a different text box.

It makes sense to me logic wise, I just don't know the expressions well enough to get it done.

Thanks all!

Alexandre
08-26-2002, 03:01 PM
I am not sure i understand where your problem lies.
Provided that you've set up your db design structure properly, you should be able to retrieve a customer's city easily through a query or in the very table wher your stored your customers' details.
It seem that you just have to base your report on the a query gathering the proper fields ?