AnsweredAssumed Answered

How to make searching while creating a new record?

Question asked by creek on Sep 29, 2011
Latest reply on Sep 29, 2011 by philmodjunk

Title

How to make searching while creating a new record?

Post

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.)

http://www.4shared.com/file/XHT9mhkN/Searching_and_New_Record.html

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.

Outcomes