Search Form (1 Viewer)

[mounty76]

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]

set the Bound column to 2?

 

[mounty76]

It doesn't have a bound column because it's a text box?

 

[mounty76]

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]

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;

 

[mounty76]

Great, thank you

 

[Gasman]

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. :-(