cancel
Showing results for 
Search instead for 
Did you mean: 

How to create 2 tables data in smartforms

Former Member
0 Kudos

Hi

I am new to smartform. I have minimum knowledge in smartform.

here I have 2 tables. I want to display 2 tables data. How to create a smartform using these two tables? I know create a smart form using one table.

Please tell me

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi lakshmi,

first fetch the data from two tables into two internal tables and passs these internal tables throgh form interface.and first create one table in main window.suppose if ur main window size is 200 cm specify the table width in details of each table as 100 cm and then divide the cells.and then pass the fields that u want to display.

please reward me if helpful.

gupta pulllipudi

Former Member
0 Kudos

Hi Laxmi

As u said u know to create one table in the same way give your second table's internal table name in form interface->tables

In global definitions mention your work area.

Now create your table in data give your internal table name into work area.

This will actually loop your internal table and flashes your data in respective cells.

In header area give your table headings and cell headings

In main area give your field names.

Hope this helps.

Regards

Swetha

Former Member
0 Kudos

Hi Swetha

Thanks for ur answer.

here i am displaying data using two tables fields.

Can u explain clearly.

Thanks

Former Member
0 Kudos

Ok you are passing fields from two different tables i believe

1)For that jus give internal tables name as i said in your form interface->tables

2)And in global data please mention your both tables work area

3)Now in main window create table and ther in data give any 1 of the internal table name into WA

4)Create loop for that right click->flowlogic->loop here mention your second table and its respective WA.

5)Under this loop create table line->row->cells.

6)Now mention your fields in respective cells as per your req

This fields can be from any of your two internal tables.

Swetha