The process of creating a lookup and incorporating that lookup into the system with intended behaviour has many stages, some of which involve complicated configuration.
In order to avoid any potential damage to your system and add the lookup into the correct areas of the system, this would need to be carried out by a member of the Access Professional Services team.
If you are interested, please contact your account manager for more information.