I have a report that a customer is selected as part of the values entered before the report is run. I need to add the customer name and address to the header of the report. I can add the name easy enough but for the address do I add that thru a sub report or is there a simple way.

Sorry I was not clear, but this may not be either. I have selected the customer name from a User field in the order header, so it is not linked to anything. I need to do a selection based on that customer name and add the address. Maybe this is not possible? Thanks for your help in advance.

The Database is like this

DBOrder_History
   Name:String [30]
   Address1:String [30]
   Address2:String [30]
   City:String[20]
   State:String [2]
   Zip:string [13]
DBCust_Master
   User_1:String [30]

I have a static selection of ten entries for the report.
The User1 record is also a drop down list for the same 10 entries.
The Entries match the Name:String in the DBOrder_History data base.

I want to use the address from the data base so that if an address changes it will be the new address in the report.

Is this enough information or am I still falling far short.....