How to make searching while creating a new record?
I have 3 tables. T1 and T2 has a relationship with T3. Table T1 has column Code1 and Table T2 has column Code2.
When I create a new record in T3 I set the value of FKID1 and FKID2. Now I use this pop-up menu. First Pop-up menu display values from column Code1 and second pop-up from Code2. It works great. (Copy database in the attachment.)
Unfortunately, I'm looking for something else. I do not want to use pop-up menu. I want to replace the pop-up menu, "a text field". I want to be able to write the value "Code" and set the relationship between T1 and T2
In the file I showed it more precisely. I am looking for a solution or example.
I have File Maker Pro 11. Please help me.