Help with DAPs

[bcbailey]

Hi 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