Blank field in Find Mode
I have two tables, Projects and Companies, joined via Projects::id_Companies and Companies::id. On the Projects layout, I have the id_Companies field as a dropdown menu that shows the names of companies instead of the id. On top of this, I placed the company name field. It does not allow entry, but exists so that I see the name of the company instead of the id. My question is, when I'm in Find Mode and select a company from the dropdown id_Companies field, the name field remains blank. Is there a way around this?