|
V
|
Vladimir 4/18/2007 |
|
Hi, |
|
|
T
|
thesofa 4/18/2007 |
Hi, I have a table with the following descr DA_NUMBER NOT NULL CHAR(8) CNECT_CODE_1 VARCHAR2(4) CNECT_QTY_1 NUMBER(5) CNECT_ITEM_PR_1 NUMBER(11,2) CNECT_CODE_2 VARCHAR2(4) CNECT_QTY_2 NUMBER(5) CNECT_ITEM_PR_2 NUMBER(11,2) CNECT_CODE_3 VARCHAR2(4) CNECT_QTY_3 NUMBER(5) CNECT_ITEM_PR_3 NUMBER(11,2) METER_CODE_1 VARCHAR2(4) METER_QTY_1 NUMBER(5) METER_ITEM_PR_1 NUMBER(11,2) METER_CODE_2 VARCHAR2(4) METER_QTY_2 NUMBER(5) METER_ITEM_PR_2 NUMBER(11,2) CABLE_CODE_1 VARCHAR2(4) CABLE_QTY_1 NUMBER(5) CABLE_ITEM_PR_1 NUMBER(11,2) CABLE_CODE_2 VARCHAR2(4) CABLE_QTY_2 NUMBER(5) CABLE_ITEM_PR_2 NUMBER(11,2) I want a form layout with the following look : Code Qty Price Value (calculated, qty * Price) CNECT_CODE1 CNECT_QTY1 CNECT_ITEM_PR_1 extended value Ditto CABLE_CODE1 CABLE_QTY1 CABLE_ITEM_PR_1 extended value Ditto Etc How can I achieve this ? Tried using the visual editor but this is an absolute pain to work with (please look at improving this for version 4). Thanks
CNECT_CODE1 CNECT_QTY1 CNECT_ITEM_PR_1
|
|
|
D
|
dcrera author 4/19/2007 |
|
You could consider putting the repeating data in a seperate table, so the data like this is held in a table on its own, then link the items in that table to the main table, this will allow you to use the master slave table system and it will show the details from the tables in a matrix.
|
|