2. ASPRunner.NET General questions
  3. Lookup values not displaed in View Page
This topic is locked

Lookup values not displaed in View Page

 		5/19/2007 3:55:04 AM
ASPRunner.NET General questions
S
 shelbig author

For Example:
I have one man members table which links to quite a few reference tables.

In the Edit screen these can be handled by changing the "edit as" display to "Lookup Wizard".

I have two questions.

  1. How do I get these Lookup values to appear in the 'View" page, as there is no option to change the "view as" option to such. This means that in the view screen I only see the ID values of the lookup table records and not the data itself. For example if I have an "Age Range" table referenced, and I have chose 20-30 in my edit screen (which relates to record 3 in my Age Range table), my only option appears to be to put up with seeing a "3" in the view screen of my main table. This is meaningless.
  2. Similarly in the list screen this also appears as a "3", which is also meaningless unless one knows the ID key values of all field in the reference tables.
    Can anyone help me please?
    Steve
S
 		shelbig author 5/20/2007

Please note that I am using ASPRunner.NET 3.0 Build 89.
I am aware that I could link the related tables into a query/view and reference the actual "lookup" values, however this is undesirable as there are many tables and it could have an adverse effect on the other ASP Runner "wizard created" functionality - possibly creating "non updateable" queries etc.
Eugene 5/21/2007

The "edit as" influence not only editing, but also list and view pages. If you set up "edit as", then you will see necessary values instead of ID's both on list and on view pages.
dcampbe11 9/4/2007

The "edit as" influence not only editing, but also list and view pages. If you set up "edit as", then you will see necessary values instead of ID's both on list and on view pages.


Eugene,
The User said she ws using the edit as and the view did not show the related table values in view but did so in list and edit mode. I too have the same the problem, only worse. Some of the lookup tables show the related text , some do not , and the view lables do not align with their appropriate filed. The view is basically useless.
Richard
Eugene 9/12/2007

We have fixed this sometime ago. Here is what you need to do:

  1. Download the latest version of ASPRunner.NET at http://xlinesoft.com/asprunnernet/download.htm
  2. Open your project and go to "Fields order and totals" page. Then go on view tab on this page
  3. Rebuild the project.
P
 		PugMaster 11/15/2007

Hi
I have been having a related problem. When you have a master table and you select the 'display master detail on page' option. The master detail only shows up as ID's not the lookup values. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23369&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
I have tried doing what was suggested in this thread but still no good.
Eugene 11/16/2007

When master detail records displaying, lookup values are not available. I would recommend on master table base to create VIEW in your database where you can define necessary lookup values