Browse Prior Art Database

Listing Data in User Panels Based on Referential Constraints Disclosure Number: IPCOM000037158D
Original Publication Date: 1989-Nov-01
Included in the Prior Art Database: 2005-Jan-29

Publishing Venue


Related People

Payne, ME [+details]


Disclosed is a new end-user interface design which allows OS/2* Query Manager Panels to provide the list of valid values for a field based on a Referential Constraint. When a table is defined as a child in a referential constraint, values within columns of the table which are defined as the 'foreign key' must match the 'primary key' in a row of the parent table in the constraint. An error message will be displayed if the end user attempts to enter a value for the 'foreign key' which is not present in the 'primary key'. Based only on this message, an end user would not know what values are valid for the 'foreign key'.