Robert:
Why don't you do a query for you select box that selects only the values
that are in the first table but not in the second. Kind of like so:
SELECT KeyID_Table1 from Table1
WHERE KeyID_Table1 NOT IN (select KeyID_Table2 from Table2)
My syntax may be off, but I think the idea is sound.
Andrew Hewitt
Web Application Developer
webworld studios, inc.
> Good Evening,
>
> The dilemma I have is that I have a table in my access database that I =
> query to fill a select box on a form the choice they make is then =
> inserted into another table with a value the values in the select box =
> can only be used once. I need to know how to query the first table for =
> the select box and then compare to the entries in the second table in =
> order to display only the available choices that are left.
>
> I hope this makes since and someone can give some guidance,
>
> Thanks,
> Robert
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
