Help With DAPs
Aug 12, 2005Hi everyone,
I'm having trouble with Data access pages.
I have a simple database with customer and orders. right now I have a Data access page (DAP) where I can pull down the customer Name and it will show me all of the orders that customer has.
But If I make a brand new customer with no orders and I go to my DAP for my orders. When I use the "group filter control" dropdown menu for the customer ID, the dropdown menu only contains customer ID's of customers who have orders.
for example, say here's my orders:
Jess - 2 orders
James - 5 orders
Jen - 0 orders
When I go to the orders page, I pull down the name dropdown and all I will see is Jess and James. But If I want to make a new order for Jen - its impossible. How can I make that dropdown show Jen's name?
Thanks
Jenny :)