AnsweredAssumed Answered

Either or lookup

Question asked by SteveKeiser on Dec 1, 2014
Latest reply on Dec 3, 2014 by SteveKeiser


Either or lookup


I have a table (Inventory) that looks up information from another table (Equipment) when an equipment ID number (what they are really picking is a foreign key) is selected in the Inventory table. At times the equipment ID is unknown, yet a record needs to be created. We have been dealing with this by entering fake numbers like "9999999". This is not a very good solution however. I have been trying to think about how to do a lookup that copies information over from the equipment table when the equipment ID is known, and copies from the Equipment table based upon the serial number when the equipment ID is unknown. I cannot think of how to go about this. Any ideas would be appreciated. (By the way, I use lookups to copy the information and not hotlinks because sometimes things get relabeled and I want the older information in the Inventory table to remain as originally copied, when things change in the Equipment table.)