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

Change column structure

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

ADezii
Expert 5K+
P: 8,750
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.Article_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.
May 27 '07 #2

Post your reply

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