Convert column data in rows

[ykhamitkar]

Hi Guys,

Can somebody help me with this.

I have Legislation table as follows

Article_No Article_Description Merchant_bank Investment_bank
================================================== =======================
1 abc true false
2 xyz true true


3rd and 4th columns tells to whom a particular article applies. 3rd and 4th columns are in checkboxes.
I have created a form to updated Legislation details.

Now i would like to change the table structure as

Legislation table
Article_No Article_Description
==========================
1 abc
2 xyz

Client it applies to
Article_No Client Applies or not
=============================
1 Merchant bank true
1 Investment bank false
2 Merchant bank true
2 Investment bank true

How can I relate these to tables in the same form.

Thanks
Yogesh

[nico5038]

Hi Guys,

Can somebody help me with this.

I have Legislation table as follows

Article_No Article_Description Merchant_bank Investment_bank
================================================== =======================
1 abc true false
2 xyz true true


3rd and 4th columns tells to whom a particular article applies. 3rd and 4th columns are in checkboxes.
I have created a form to updated Legislation details.

Now i would like to change the table structure as

Legislation table
Article_No Article_Description
==========================
1 abc
2 xyz

Client it applies to
Article_No Client Applies or not
=============================
1 Merchant bank true
1 Investment bank false
2 Merchant bank true
2 Investment bank true

How can I relate these to tables in the same form.

Thanks
Yogesh

Hi Yogesh,

I have a hard time understanding why you would want this.
Personally I would expect a tblBank table containing a bank's name and type.
Then the article can be linked to such a bank and when multiple banks could be connected an additional tblArticleBank to hold the relations can be used.

Getting the idea ?

Nic;o)