report help needed thanks

[misschanda via AccessMonster.com]

have a report based on the below sql. In the report the user can chooses
which data he/she wants to use based upon the entered parameter [orderdetails]

! [orderid].

The subform sql report is also based below.

The problem I am encountering is in the Master/Child field linkage. I am
using the Link Master Field = Orders.orderid ( i have also tried orderdetails.

orderid)
and the Child Field as [orderid]. when I include this I am prompted for the
order id, which is good, But also orders.... orders is the name of the table
that includes the field orderid.

When I do not use the linkage all is okay.. the subform yields all data but
still good.

I have tried removing the linkage fields and compacting, as directed by an
archive post, but still not help.

any help appreciated.

REPORT:

SELECT DISTINCTROW Orders.*, OrderDetails.*, SampleDetails.*, Customers.*,
Priorities.Text AS [Priority Text], CustomerAddresses.*, [City] & ", " &
[State] & " " & [ZipCode] AS CSZ, [Enter Order ID] AS Expr1
FROM (((Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.
CustomerID) INNER JOIN (OrderDetails INNER JOIN SampleDetails ON
(OrderDetails.SampleNumber = SampleDetails.SampleNumber) AND (OrderDetails.
OrderID = SampleDetails.OrderID)) ON Orders.OrderID = OrderDetails.OrderID)
INNER JOIN Priorities ON SampleDetails.Priority = Priorities.Priority) INNER
JOIN CustomerAddresses ON Orders.CustomerID = CustomerAddresses.CustomerID
WHERE ((([Enter Order ID])=[Orderdetails]![orderid]));

SUBFORM:

SELECT Setup_SampleConditions.QuestionText, Orders_SampleConditions.Answer,
Orders_SampleConditions.OrderID
FROM Orders_SampleConditions INNER JOIN Setup_SampleConditions ON
Orders_SampleConditions.QuestionID = Setup_SampleConditions.QuestionID;

 

[Duane Hookom]

I would remove the SELECT * and use only the unique field names in the main
report's record source. This would allow you to use only the field names in
the link master/child properties.

IMHO, parameter queries are not good user interface. You should be using
controls on a form for all user interaction.