Two controls with the same name...

[wrek]

Don't mean to become a pain on this board but....

I have a report with the same name for two different fields: Facility and Unit. They are two different controls and have two different sources. So the source and the names of the fields are:

Change Data.FACILITY & Change Data.UNIT & ORSUSRECHDR.FACILITY & ORSUSRECHDR.UNIT

The underlying query for the rpt runs fine. But when I try to run the rpt, it says:

"The specified field Change Data.Facility can refer to more than one table in the FROM clause of your SQL statement."

There's only one table Change Data in my query. What's up?

(It is, however, the 2nd part of a 2-part query, with Change Data also in the 1st part...does that affect it?)

 

[Rich@ITTC]

Hi wrek

I would check your query carefully to make sure you have not accidently added the same field twice (it is very easy to do, especially with quite complex queries).

If you run the query (not the report) and look for any fields with a column heading like Exp1001, then that is likely to be your culprit.

HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 07-24-2001).]

 

[wrek]

No, I suspected that too, so I checked that pretty carefully...Facility and Unit are in there twice but with different sources

(you respond pretty damn quick, you monitor these boards or sumthing?)

 

[Rich@ITTC]

Hi wrek

Sometimes!

Have you checked using SQL view - just to see if the name/reference is repeated somewhere?

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 07-24-2001).]