Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Table db Design > standard rel. r...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 12065 of 12659
Post > Topic >>

standard rel. rules between 2 main frms with 1-1 rel. and sub fo

by =?Utf-8?B?VHJhdmVsaW5nSFQ=?= <akwillims75@[EMAIL PROTECTED] (stopthespa Jul 31, 2008 at 07:32 AM

Dear All:

I have created a form and tables for taking in the info from a 
questionnaire. For reasons of insanity and trying to keep to the rules of
4th 
normal planning for my questionnaire, I have created a one to one 
relation****p between the questions always answered and some questions only

some times answered to save space. 

To connect the two primary forms I created a primary key with auto number
in 
the Always Used Main Table and linked it to a primary key using long
integer 
(No Duplicates) in the Sometimes Used Main Table. 

I set up an If statement to send the tab to a sub form in the Sometimes  
Main Form which worked fine, but Ctrl+Tab out of the subform into another 
subform did lots of weird things depending on if there was a value in the 
first subform, if I added another entry then Ctrl+Tab to the point I could

not keep track of the variables that would create the changes. 

I then looked at my relation****ps and added a one to many link from the 
Sometimes Used Main Table to all the sub tables and now things are working

fine. 

Originally there was only the One to One relation****p between the two main

forms and a  One to Many relation****ps between the Always Used Main Forms
and 
the Subforms.

This now means that both the Always Used Main Table and the Sometimes Used

Main Table both have One to Many relation****ps with all of the sub tables
and 
a One to One relation****p between the two of the Main Tables!

Is this normal, is it an abomination, what are the rules, can I go to
prison 
for this? 

Where can I find out about the conventions on this type of situation?

Thanks in advance.

TravelingHT
 




 8 Posts in Topic:
standard rel. rules between 2 main frms with 1-1 rel. and sub
=?Utf-8?B?VHJhdmVsaW5nSFQ  2008-07-31 07:32:00 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
"Steve" <non  2008-07-31 10:57:41 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
=?Utf-8?B?VHJhdmVsaW5nSFQ  2008-07-31 13:22:10 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
"Steve" <non  2008-07-31 18:39:02 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
=?Utf-8?B?VHJhdmVsaW5nSFQ  2008-08-04 08:50:14 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
"Steve" <non  2008-08-04 15:02:10 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
"Larry Daugherty&quo  2008-07-31 15:53:58 
Re: standard rel. rules between 2 main frms with 1-1 rel. and
=?Utf-8?B?VHJhdmVsaW5nSFQ  2008-08-04 08:52:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 21:38:49 CST 2008.