Ultimatel, I want to populate a lookup window from a table with the dealerid. The source table is a transaction table and has thousands of records.
The field dealerid is not unique in this table.
If I were to do this in sql, I would write the select statement
select distinct dealerid from sourcetable.
However, there is no equivalent in Dexterity.
Essentially I want to fill the lookup window the unique dealerid in my source table.
regards
Hi Mike
I would create a Dexterity Table definition that has the fields and indexes that you want for the final data.
Then in the Form Pre script, you can populate the table. using a SQL Select into statement using SQL_Execute. Use the Table_GetOSName() command to get the physical SQL path for the temp table.
This method works really well and does not need a view.
Regards
David
create view for your sql query.
like below
create view
DealerLookup
as
select distinct CUSTNMBR as dealerid,ROW_NUMBER() OVER(ORDER BY CUSTNMBR ASC) AS DEX_ROW_ID
from SOP10100
GO
P.S : change your table name.
then in dexterity create a table like below.
now attached your table to lookup scroll window and on window pre event just write fill window, it will fill records from the view.
almas
your dexterity developer ;-)
I know the Dexterity manuals have information on lookups and lookup windows, though I imagine you've been through these already?
I know there are members of the Community that do much work with Dexterity that may have more information to suggest.....
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156