Error: "Name not unique in this context"

rbuser

Hi

I'm trying to link two queries when both are using the same tables and
calculations with different criterias and when I try to veiw the data from
detail query it displays this message "Name not unique in this context".

Query1 Master
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2001" )
GROUP BY ReceiveDetail.MasterID

Query2 Detail
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2002" )
GROUP BY ReceiveDetail.MasterID

its linked by the MasterID

if anyone knows how to bypass this error let me know please.

Thanks
Sam

digitalmetaphors

You do not mention which version of RB you are using and whether or not you
are using DADE to create these queries or if you are using queries on a
form/datamodule. It looks like you are using DADE because the detail query
is not parameterized. If you are using DADE, then I assume you are using a
5.5x version. Please use the latest version (RB 7.01) to get the best and
latest support for linking in DADE.
Cheers,
Jim Bennett
Digital Metaphors