[AccessD] Aquuarium existing structure

John W. Colby jwcolby at gmail.com
Wed Mar 4 12:00:48 CST 2015


The aquarium thus has a name, the hardness type, a tank size, and a memo 
for adding notes.

You have already seen the fish table but I will put a couple of records 
into this email.

*tblFish* ID 	FI_TankSize 	FI_Difficulty 	FI_Temperament 	FI_TempLow 
FI_TempHi 	FI_HardnessLo 	FI_HardnessHi 	FI_PHLo 	FI_PHHi 	FI_MaxSize 
FI_Price 	FI_Name 	FI_URL
2 	20 	Easy 	Peaceful 	68 	85 	3 	10 	6.5 	8 	3.5 	12.99 	Singapore 
Flower Shrimp 
_http://www.liveaquaria.com/product/prod_display.cfm?c=1075+1842&pcatid=1842_ 

3 	10 	Easy 	Peaceful 	68 	85 	3 	10 	6.5 	8 	2 	1.99 	Grass Shrimp 
_http://www.liveaquaria.com/product/prod_display.cfm?c=1075+3347&pcatid=3347_ 



tblFish This basically just copies much of the descriptor data from one 
specific site (LiveAquaria.Com) which I found last night.  I started 
this in an excel spreadsheet so the Difficulty and Temperament should 
really be carved out into child type tables.  They currently are not.

-- 
John W. Colby



More information about the AccessD mailing list