Andrew
|
Posted: 09/23/2003, 1:27 PM |
|
This time it happenned in an editable grid (order_items)....when I add the products table to the "Build Query", the order_items records no longer appear. Remove the products table, and they show up again. I don't even add a field from the products table to the grid. Relationships are set correctly....what gives??!
Frustrated
|
|
|
Andrew
|
Posted: 09/23/2003, 1:48 PM |
|
Oh yeah.... ASP vbscript MSAccess.. very latest (just updated) version of CC Studio
No one ever answers my posts boo hoo
|
|
|
Alice
|
Posted: 09/23/2003, 5:26 PM |
|
Sounds like your SQL query is returning no recordset when the related table is include.
Run the query in ACCESS to get your result and then check against the CCS generated query.
It ain't CCS, it's your query - check for NULL values too, as any record with a null doesn't join the recordset.
|
|
|
Andrew Reilley
|
Posted: 09/24/2003, 8:19 AM |
|
You were exactly right. The child table had no information to relate it to the master.
|
|
|
|