[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