var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Matrix situation in MS ACCESS
Fields: DbContract pk
in table data is like:
dbcontract item_no title quantity
1 89 Roadway 10
1 89 Bridge 20
1 89 Ground 30
1 90 Roadway 10
1 90 Bridge 20
1 90 Ground 30
Note: title varies with every new entry....
Now user is entering data in this format:
roadway bridge ground
89 10 20 30
90 10 20 30
i hope i convey you my problem. if i didn't please let me know. I think it is some matrix situation.
data is in row but i want to capture or display in columns and Data would be updateable and editable.
Thanks for time and cooperation.
Waiting for reply.
Why do you have 3 primary keys in the same table? I suggest you re-evaluate your table structure. From what I can see, you should have another table for items.
This table is child of Off_item table.
Thats why i had that primary key in detail table.