Two table query not allowing entry.

[Guest]

I've created a two table query, table 1 has acctnumber, Ordernumber,
Ordertype, DFlag, OrderDate. The second table is linked on the Ordertype and
the only column used is the description. I've then created a form that uses
this query to display all orders for a given acctnumber, I want to be able to
click the DFlag which is a Yes/No for those orders I want to display. My
problem is because I'm using two tables it will not let me click the yes/no
box it just keeps beeping. Is there a way to allow for data entry into the
yes/no check box so I can then display only those records that have the check
box selected.
Thanks for any help
CD Tom

 

[Duane Hookom]

Is Ordertype the primary key in the "second table"?

 

[Guest]

Yes
I did find out that because I want to only show unique values that it will
not work. I can understand why, but wish there was a way I could do what I
want. What I'm looking to do is display the orders for a given customer,
then allow the user to check which orders they want to view, by placing a
check in the yes/no box. When the user is finished I could loop through those
orders with a check in the yes/no box and display the complete order. Any
ideas
Thanks

 

[Duane Hookom]

You might be able to use a multi-select list box rather than check boxes.

 

[Guest]

Thanks I'll give that a try.

You might be able to use a multi-select list box rather than check boxes.