Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

dynamicly hide/show column in a grid

edited Apr 7, 2016 5:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 3 commentsAnswered

i modify an existing application to give it a one to many relationship. on an edit form, it has user's details and one of the field (Access) has UDC values as below. People will select 1 or 2 (there are a lot of UDC values, below are just example). 

Code     Description 1                                        Description 2

1           View all people in a department             HMCO

2           View all people in a company                CO

To create a many relationship, i created a new table and it will have 2 columns, department and company columns besides the userid column. If Access is 1 then the HMCO column will be filled in with 1 or more records.  If Access is 2 then the CO column will be filled in with 1 or more records.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center