| Subject: | text values in search form for has_a and has_many |
The database for my application is large, and it takes forever to
generate the dropdown lists in the search form (and add form, but adds
are rarer and I have moved addnew to a seperate page). Some tables have
thousands of rows and will soon have tens or hundreds of thousands of
rows. Obviously, generating these dropdowns is cost prohibitive. Would
it be possible to make a processor or something that would say in effect:
generate a text box for this field... when the search is processed, join
on the related table and match the form text to the Stringify column of
the related table?