I have 2 tables; Menu & Restaurant.
Restaurant columns: RestID / RestName
Menu columns : Menu ID / MenuName / RestID (linked to record) / RestName (lookup)
I’m creating a form on Menu table to ab able to add new records. In the form, I’d like to lookup the associated restaurant using RestName. However only RestID column is available in the form and the “find an option” popup doesn’t show me the Restaurant name so it’s difficult to identify the right restaurant.
How can I get the find popup to show the restaurant name.