A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

1-1 relationship and data entry



 
 
Thread Tools Display Modes
  #1  
Old February 13th, 2009, 10:40 PM posted to microsoft.public.access.tablesdbdesign
denise
external usenet poster
 
Posts: 388
Default 1-1 relationship and data entry

How can I ensure that data is entered in the 2nd table (non-public) in a 1-1
relationship? Because the join is 1-1, it is presenting a problem when data
is not entered in 2nd table. In this situation, Access will show all records
in table 1 (public data) . When I query tables 1 & 2 together, the records
that do not have data in table 2 are not in the results.

I need a way to automatically enter a data element in table 2 working around
the human error problem.
Thanks.
  #2  
Old February 14th, 2009, 07:58 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default 1-1 relationship and data entry

On Feb 13, 3:40*pm, Denise wrote:
How can I ensure that data is entered in the 2nd table (non-public) in a 1-1
relationship? *Because the join is 1-1, it is presenting a problem when data
is not entered in 2nd table. *In this situation, Access will show all records
in table 1 (public data) . *When I query tables 1 & 2 together, the records
that do not have data in table 2 are not in the results.

I need a way to automatically enter a data element in table 2 working around
the human error problem.
Thanks.


use a single table and views to control who sees what? (and base your
data entry form on the table)
  #3  
Old February 14th, 2009, 04:00 PM posted to microsoft.public.access.tablesdbdesign
denise
external usenet poster
 
Posts: 388
Default 1-1 relationship and data entry



"Piet Linden" wrote:

On Feb 13, 3:40 pm, Denise wrote:
How can I ensure that data is entered in the 2nd table (non-public) in a 1-1
relationship? Because the join is 1-1, it is presenting a problem when data
is not entered in 2nd table. In this situation, Access will show all records
in table 1 (public data) . When I query tables 1 & 2 together, the records
that do not have data in table 2 are not in the results.

I need a way to automatically enter a data element in table 2 working around
the human error problem.
Thanks.


use a single table and views to control who sees what? (and base your
data entry form on the table)

I can't keep in same table because the table with public data will
ultimately be linked to for other databases. The non-public data must not be
comprised. Thank you for your suggestion, however.
  #4  
Old February 14th, 2009, 06:15 PM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default 1-1 relationship and data entry

I need a way to automatically enter a data element in table 2

no, you don't - and you don't *want* to enter a record in table 2 until you
actually need to enter valid data in that table. instead, in your query, use
a Left Join, as MVP John Vinson explained in your other thread in this
newsgroup - that will allow you to see all the records in table 1, whether
or not there are related records in table 2.

hth


"Denise" wrote in message
...
How can I ensure that data is entered in the 2nd table (non-public) in a

1-1
relationship? Because the join is 1-1, it is presenting a problem when

data
is not entered in 2nd table. In this situation, Access will show all

records
in table 1 (public data) . When I query tables 1 & 2 together, the

records
that do not have data in table 2 are not in the results.

I need a way to automatically enter a data element in table 2 working

around
the human error problem.
Thanks.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.