I'm trying to set up a basic database of local apples. My main page has a variety of fields about the apples (taste, texture, color). I've created a lookup table with two fields: orchard and apple variety. When I try to set up the apple variety field in my datapages as a cascading dropdown - where selecting the orchard will pull up a list of apples produced by that orchard - the dropdown shows duplicate entries for the orchards, even though I have the distinct options box checked. What am I doing wrong?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
ChristinaPerucci
I'm trying to set up a basic database of local apples. My main page has a variety of fields about the apples (taste, texture, color). I've created a lookup table with two fields: orchard and apple variety. When I try to set up the apple variety field in my datapages as a cascading dropdown - where selecting the orchard will pull up a list of apples produced by that orchard - the dropdown shows duplicate entries for the orchards, even though I have the distinct options box checked. What am I doing wrong?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.