N
Nikki
I've been searching for a while on this, but I haven't found the right
keywords to get to my answer.
I'd like to create a Lookup field that only displays values that have
not been selected in previous records for this same field in this same
table. For instance, if I'm assigning pieces of candy to children,
but I have only 1 of each flavor, once I select grape in the first
child's record, I don't want grape to display as an option in the drop
down anymore for future records. If that can't be accomplished in the
table itself, but a form, that's fine too of course.
I'm using Access 2007 and believe it or not, I'm fairly comfortable
with Access and even somewhat comfortable with VB and SQL. My brain
refuses to wrap around this one though.
keywords to get to my answer.
I'd like to create a Lookup field that only displays values that have
not been selected in previous records for this same field in this same
table. For instance, if I'm assigning pieces of candy to children,
but I have only 1 of each flavor, once I select grape in the first
child's record, I don't want grape to display as an option in the drop
down anymore for future records. If that can't be accomplished in the
table itself, but a form, that's fine too of course.
I'm using Access 2007 and believe it or not, I'm fairly comfortable
with Access and even somewhat comfortable with VB and SQL. My brain
refuses to wrap around this one though.