Sorry to post as new thread, I have asked question before so please
accept my apologies.
I have created Database in Access 2007 MyCollection with following tables..
1. tblPostalIssues (PostalIsuID pk auto, Desc,Subject)
2. tblStamps (StampID pk auto, PostalIsuID fk,other fields)
3. tblSpecs (SpecID pk auto, other fields)
4. tblVarieties (VarietyID pk auto,SpoecID fk,VarietyType)
Relations...
tblPostalIssues 1:M tblStamps
tblStamps 1:M tblSpecs
Now my dilema is Specifications are PostalIssues as well as Stamps
PostalIssues Specs are as the Issue Authority Declared most of the time (some time not)
Stamps Specs some stamp may have same specs as Issued Issue. But other might have
differrent specs either one of the specs or more that one Specs different.
How I should relate Table Varieties...
Should I take Fk as StampID or SpecID, Or stampId and SpecID also
Should I put y/n field in tblSpecs ( Both specs Same, Specs Deffers)
Also These Varieties are categorize as ERRORS which are Major errors and
other Defferences as EFO as 1.Error minor 2.Freak 3. Oddities on defferent
Crieteria of Specs and Definitions are Ildefined.
Can some body guide me or advise me.
Attached is the screenshot of Relationships.
View attachment DBV20Screen.zip
Thanks in advance.
Kahalkmu
accept my apologies.
I have created Database in Access 2007 MyCollection with following tables..
1. tblPostalIssues (PostalIsuID pk auto, Desc,Subject)
2. tblStamps (StampID pk auto, PostalIsuID fk,other fields)
3. tblSpecs (SpecID pk auto, other fields)
4. tblVarieties (VarietyID pk auto,SpoecID fk,VarietyType)
Relations...
tblPostalIssues 1:M tblStamps
tblStamps 1:M tblSpecs
Now my dilema is Specifications are PostalIssues as well as Stamps
PostalIssues Specs are as the Issue Authority Declared most of the time (some time not)
Stamps Specs some stamp may have same specs as Issued Issue. But other might have
differrent specs either one of the specs or more that one Specs different.
How I should relate Table Varieties...
Should I take Fk as StampID or SpecID, Or stampId and SpecID also
Should I put y/n field in tblSpecs ( Both specs Same, Specs Deffers)
Also These Varieties are categorize as ERRORS which are Major errors and
other Defferences as EFO as 1.Error minor 2.Freak 3. Oddities on defferent
Crieteria of Specs and Definitions are Ildefined.
Can some body guide me or advise me.
Attached is the screenshot of Relationships.
View attachment DBV20Screen.zip
Thanks in advance.
Kahalkmu