<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9739&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> Anyone know how you can use a lookup table to select a uniqiue number based on two fields?
I need to create a lookup (drop down) that only allows the user to select items that have not been previously selected in the same field on another record. And to complicated it more it needs to be dependent on another lookup table field as well.
Example:
I have a lookup table that is populated from another tables field called board number. For each board I have a possible 120 slots available. I want the user to only be able to select the numbers available that haven't been selected before with the same board number.
I thought about just using one field and just add the board number and the slot (B001S001, B001S002, B001S003, etc.) but I still don't know how to make the already selected items not available.
Any help would be appreciated.
Thanks