By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,673 Members | 1,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,673 IT Pros & Developers. It's quick & easy.

Convert column data in rows

P: 64
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
May 26 '07 #1
Share this Question
Share on Google+
1 Reply

nico5038
Expert 2.5K+
P: 3,072
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)
May 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.