You also have a third choice: The R:Base syntax allows you to use #n where n is the ordinal position of the column within the table. E.g. if you do a LIST tablename, and see that Compname is the 4th column, and Addr1 is the 6th column, and Zipcode is the 10th column, then this:
((LJS(Compname,30)) & (LJS(Addr1,30))&Zipcode) could be written like this: (LJS(#4,30) & LJS(#6,30) & #10) The downside is that it is hard to understand by looking at it, and it is hard to maintain, and if you ever change the order of columns in the structure of the table, good luck thinking of this obscure side effect. Bill On Wed, 20 Aug 2003 09:24:36 -0500, Sami Aaron wrote: >Well you have two choices - >1. Create a view based on the lookup table with really short column alias >names. Like this: >CREATE VIEW shortlookupvw (C1,C2,C3,C4,C5) AS + > SELECT >longcolumname1,longcolumname2,longcolumname3,longcolumname4, longcolumname5 + > FROM tablename >then do the pop-up on the view using these short column names. >2. follow Dennis's suggestion and change to using an EEP on the field >rather than the form pop-up.
