Search Form (1 Viewer)

mounty76

Registered User.
Local time
Today, 15:33
Joined
Sep 14, 2017
Messages
177
Hello!!


I am modifying Allen Browne's simple search form that he has on his website, one thing I'm struggling on is:

The data returned in the search results are numbers that relate to the linked table. Is there anyway to return the responding text that appears in the combo box?


Cheers
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:33
Joined
May 7, 2009
Messages
14,555
set the Bound column to 2?
 

mounty76

Registered User.
Local time
Today, 15:33
Joined
Sep 14, 2017
Messages
177
It doesn't have a bound column because it's a text box?
 

mounty76

Registered User.
Local time
Today, 15:33
Joined
Sep 14, 2017
Messages
177
I'm actually after something similar to this search form, but whereby the results are shown in a query so that I can do more with the result (IE create a report from them)

Is there a simple way to do this?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:33
Joined
May 7, 2009
Messages
14,555
on your query, add the Lookup table (join) and include the "text" part from that table.

example:
you only have partID in table1 and you need the "description" of it which can
be found in table2 (table2 struc: partID, description).

select table1.* table2.description from table1 left join table2 on table1.partID = table2.partID;
 

Gasman

Enthusiastic Amateur
Local time
Today, 23:33
Joined
Sep 21, 2011
Messages
9,276
It is not recommended to use lookup fields on tables. Just so you know.
Search here as to why not, plenty of threads with links as to why not, not including the fact that, that is how lookup fields work and most people not aware. :-(
 

Users who are viewing this thread

Top Bottom