This topic is locked

v4.1 Foreign Key Lookups on List, View and Print Pages

1/10/2007 10:07:55 AM
ASPRunnerPro General questions
G
gverras author

I am putting together a list page on a table that contains FK pointers to Lookup tables for some of its columns. I don't want it to display the FK, just the translated value. How do I do this in V4.1?

Sergey Kornilov admin 1/10/2007

Proceed to the Edit page in Visual Editor and set Edit type of those fields to Lookup Wizard pointing to lookup tables.

In this case list page automatically displays data from lookup tables.

G
gverras author 1/16/2007

OK. I didn't have an Edit page checked off for my app, because I only needed the list but I see that it uses Edit screen FK relationships on other pages.
Thanks

G
gverras author 1/19/2007

OK. I didn't have an Edit page checked off for my app, because I only needed the list but I see that it uses Edit screen FK relationships on other pages.

Thanks


I found out that if the FK liknks to a table with 25000 records, it marshalls the entire recordset to the client in order to display that one dropdown value. How about add Large List selectors to an upcoming version of ASPRunner? Or the ability to just display the translated value instead of a dropdown?