Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

table view

manubhutani
Active Contributor
0 Kudos
87

Hi..

I have 2 tables... table1 and table2.

table1 has 3 fields A B C and table 2 has 3 fields D E F ( fields A B E F are primary keys, A = D, B = E )

now i want to display all the fields ie A B C F or D E C F (one and same thing)

i can do this using DB view.. but now user wants to edit the field F in the same view

How can i acheive this scenario, in maintenance view also, we can have just 1 table

please help

Regards

Manu

4 REPLIES 4

former_member208517
Participant
0 Kudos
39

why not create an addon program which using the table control to fulfill this requirement.

if you just want to fullfill this requirement using view.

I think view clauster can make it happy. But you should take some time to see how the view clauster work.

Good luck.

former_member776318
Participant
0 Kudos
39

Hi,

This is possible.

But, what I did not get to understand is that if you have A = D & B = E, then it would logically mean that there would be only one table with the key fields as A & B while the non-key fields as E & F. That way it would also be easier to maintain.

Whatever, May be you can explain about this scenario later.

Solution to your problem:

1. Your requirement can be fulfilled with Maintenance Views. A maintenance view can have more than one table

2. There should be foreign key relationship between your tables.

Here is how you can achieve it:

Step-1: Create your Table-1 with fields A, B & C

Step-2: Create your Table-2 with field D, E & F

Step-3: Establishment of Foreign key relationship between the two tables

In your Table-2, Define the check table for field D against the field A of Table-1. When you press the foreign key field button, you'll get a popup. In the semantic-attributes of this popup, select Foreign Key field type as KEY FIELDS/CANDIDATES & select the cardinality as 1:1 (in your case).

Perform the similar task for Table-2 Field E and Table-1 Field-B.

STEP-4: Declare a maintenance view. In the tab "Table/Join Conditions", enter the Table-1. Then hit the push-button "Relationships", which is present at the bottom. You'll get a pop-up containing a list of Dependent Tables indicating that Table-2 is dependent on Table-1. Select this entry.

When you do this, your join conditions will be created automatically in the table-control on the right.

STEP-5: Go to the tab "View Fields".

The fields of the Table-1 would be present by default. Hit the push-button "Table Fields", then select the Table-2 & then select only the field F.

This way you can create a maintenance view to maintain the primary & foreign key table simultaneously.

Hope that is helpful to you.

Let me know if you have any queries regarding the same.

Regards,

Saurabh

Former Member
0 Kudos
39

Hi Manu,

As you are saying F is a Key Field.It is not possible to edit Key Filed.

Check your Requirement again .

Thanks

Sai

Former Member
0 Kudos
39

Hi Manu,

Sai is right if the field is a primary key, you cant edit it its logical also right... and if the field is not a primary key it will be in editable mode only...create table maintenance generator for maintenance view...

Hope this helps