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  

Relationship Help



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2009, 06:02 PM posted to microsoft.public.access.tablesdbdesign
lettyg
external usenet poster
 
Posts: 14
Default Relationship Help



I have uploaded a screen shot of my relationships window for the database I
have designed. I believe what i want is a one to many relationship. The
Parent Table is FCCaseInfo and its primary key is CaseIdNo. The child tables
should be FVVW, FVCharges, and FVDates these tables also have the CaseIdNo
(not primary, but i added this field to somehow relate all of these
together).

Any suggestions as to what my relationships should be?

Thanks!
  #2  
Old December 23rd, 2009, 06:04 PM posted to microsoft.public.access.tablesdbdesign
lettyg
external usenet poster
 
Posts: 14
Default Relationship Help

I have uploaded a screen shot of my relationships window for the database I
have designed. I believe what i want is a one to many relationship. The
Parent Table is FCCaseInfo and its primary key is CaseIdNo. The child tables
should be FVVW, FVCharges, and FVDates these tables also have the CaseIdNo
(not primary, but i added this field to somehow relate all of these
together).

Any suggestions as to what my relationships should be?

Thanks!

http://cid-af7c698d9d142706.skydrive...c/Database.JPG
  #3  
Old December 23rd, 2009, 06:42 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Relationship Help

You know your topic much better than we do ...

You need to tell US what the relationships are!

For example, how many [FVVW] records could you see for each single CaseIDNo
(parent record)?

How many [FVCharges] records per CaseIDNo?

?[FVDates] per CaseIDNo?

(by the way, we're taking you at your word that [FVVW], [FVCharges], and
[FVDates] are "child" tables. But you haven't described the type of data
that you're storing in any of the four tables, so we're unlikely to be able
to offer our observations on whether you have modeled your data
relationally, or have "committed spreadsheet".)

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"lettyg" wrote in message
...


I have uploaded a screen shot of my relationships window for the database
I
have designed. I believe what i want is a one to many relationship. The
Parent Table is FCCaseInfo and its primary key is CaseIdNo. The child
tables
should be FVVW, FVCharges, and FVDates these tables also have the CaseIdNo
(not primary, but i added this field to somehow relate all of these
together).

Any suggestions as to what my relationships should be?

Thanks!



  #4  
Old December 23rd, 2009, 07:32 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Relationship Help

IMHO, if you put the CaseID number into those three "child tables" are are
able to put a single CaseID number into that field in each of those child
records, the you have already essentially created and told us about the
relationships, determined that they are not many-to-many, and all that
remains is to "draw the lines" between the CaseID field to the field of that
name in each of the child tables. You'll still have some secondary choices
to make (referential integrity and which, if any, unmatched records that you
so (which will presumably be those of your parent table)
 




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 09:03 AM.


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