MySQL Forums
Forum List  »  Microsoft Access

Help with DAPs
Posted by: bcbailey
Date: August 12, 2005 03:03PM

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?


Options: ReplyQuote

Written By
Help with DAPs
August 12, 2005 03:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.