Change column structure

[ykhamitkar]

Hi Guys,
I am Yogesh

Can somebody help me with this.

I have Legislation table as follows

(* "-" is used to indicate space)
-Art_No--Art_Text--Bank---Fin_Inst
=============== =============== =
-1-------abc-------true---false
-2-------xyz-------true---true


3rd and 4th columns tell 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
-Art_No--Art_Text
=============== =============== =
-1-------abc-----
-2-------xyz-----

Client it applies to
Art_No---Client----Applies
=============== ==============
-1-------Bank------True
-1-------Bank------False
-1-------Bank------True
-1-------Bank------True

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

Thanks
Yogesh

[ADezii]

Hi Guys,
I am Yogesh

Can somebody help me with this.

I have Legislation table as follows

(* "-" is used to indicate space)
-Art_No--Art_Text--Bank---Fin_Inst
=============== =============== =
-1-------abc-------true---false
-2-------xyz-------true---true


3rd and 4th columns tell 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
-Art_No--Art_Text
=============== =============== =
-1-------abc-----
-2-------xyz-----

Client it applies to
Art_No---Client----Applies
=============== ==============
-1-------Bank------True
-1-------Bank------False
-1-------Bank------True
-1-------Bank------True

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

Thanks
Yogesh

1. Your prior Post concerning this same Topic was deleted - Please do not double post your questions. It makes it very confusing for Moderators/Experts who are trying to assist you in resolving your questions.
2. If you haven't already done so, relate your 2 Tables in the following manner: Legislation.Art icle_NO(1) ==> Client.Article_ NO(MANY).
3. Create a Query consisting of Field from both Tables. If step 1 was completed, the join will automatically be created.
4. Make this Query the RecordSource for your Form.
5. Consider making Client a Sub-Form consisting of the 2 Fields. If you choose to do this, your Parent Form will be based on Legislation and your Child Form will be based on Client data.
6. If you need further assistance, let us know and someone will be along to help you.