A datasource has to be based on a table in order to make inserts, updates and deletes. That table may have foreign keys to tables with more information, for example someone's first name and last name.

How can I show these "lookup data"?

Offcourse I have read the tutorial about comboboxes, but there are lookup tables with thousands of records.

asked 26 Sep '14, 05:40

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
accept rate: 0%

Hi Jan-Willem,

In the application we are building we always use views with instead-of triggers for the screen datasources. Among one of the advantages of working like this is that you decide in the database viewhow to query the lookup data for your screen. Then if you have a large lookup table usage in your screen, just use an LOV, for smaller lookup tables you can use a simple combobox.

Good luck, Michiel A.


answered 28 Sep '14, 05:33

Michiel%20A's gravatar image

Michiel A
accept rate: 13%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 26 Sep '14, 05:40

Seen: 3,265 times

Last updated: 28 Sep '14, 05:33

© Copyright Gerger 2017