How to make searching while creating a new record?

[Creek]

Hi All. This my first post in this forum.

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

(This post is a copy of my message from another forum. I hope this is fine)

[LaRetta]

Hi Creek! Welcome to FM Forums!

When you use abstracts, we cannot tell the purpose. When we cannot tell the purpose then we cannot make logical suggestions. T1 and T2 are identical. That is not usually the approach to take but then again, I have no idea what you are trying to accomplish.

Whether you type a key or select it from a pop-up, the result is the same ... the data goes into the field and, if it matches data on a related side, it will create a relationship and the related data will be available to the main table. But please explain your real-life situation so we can better assist. :^)

[comment]

I want to be able to write the value "Code" and set the relationship between T1 and T2

Do you mean something like the attached?

LookupID.zip

[Creek]

Do you mean something like the attached?

Yes. This is exactly what I was looking for.

Thank you very much indeed.