[AccessD] Existing structure

[John W. Colby]

I will paste my existing structure so you can see where I am going with 
this and make suggestions.  AQ_Type is just a text descriptor out in a 
table.  It could contain the hardness numbers, I chose not to.

*tblAquariumType* AT_ID 	AT_Typ
1 	Soft
2 	Hard
3 	Salt
4 	Med

tblAquariumType
The aquarium then allows me to define aquariums to be set up.

*tblAquarium* AQ_ID 	AQ_Type 	AQ_HardnessLo 	AQ_HardnessHi 	AQ_Name 
AQ_Gallons 	AQ_Notes
1 	Soft 	0 	8 	First 	75 	
2 	Med 	6 	12 	Second 	50 	
3 	Hard 	10 	30 	Third 	60 	

tblAquarium

-- 
John W. Colby