Skip to main content

Hi,


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.



Regards,


Ruchika

My workaround is to have three fields:





  • RestNumber (Single Line Text or Number)


  • RestName (Single Line Text)


  • RestID (Formula which concatenates the other two fields) > Set as primary field




Concatenating the two fields together will allow you to find a restaurant by both name and ID number.

My workaround is to have three fields:





  • RestNumber (Single Line Text or Number)


  • RestName (Single Line Text)


  • RestID (Formula which concatenates the other two fields) > Set as primary field




Concatenating the two fields together will allow you to find a restaurant by both name and ID number.


Hi Kamille,



Thanks! I’ve tried this for a couple of tables. I’m just worried as I import the Restaurant and Menu from another database and primary keys will be the IDs there.



Regards

Reply


Terms & Conditions