[AccessD] Aquarium existing structure

[John W. Colby]

ATM tblAquariumFish holds just the aquarium id and the fish ID, and a 
quantity, and represents the fish selected for a specific aquarium.

*tblAquariumFish* AQFI_ID 	AQFI_IDAQ 	AQFI_IDFI 	AQFI_Qty
1 	0 	2 	3

tblAquariumFish
This should allow a query to pull the data for the selected fish, the 
hardness rating, as well as the tank inches and the quantity of the 
selected fish.  With that data the process of filtering for possible 
fish can begin.

 From this point, the min / max query can start populating based on fish 
selected into tblAquariumFish.  It just occurred to me that I really 
need a field in tblAquariumFish to indicate whether the selected fish is 
already purchased (in the tank) or is being proposed.  Obviously 
existing (purchased) fish should not be removable in the same sense as 
the proposed fish are.  IOW you can add / subtract proposed fish but 
existing fish should remain (in the selection process).  If you want to 
MOVE a fish, then they should be moved to another aquarium and deleted 
from this one.

If you use a combo to select the proposed fish, then the FIRST TIME (the 
table is empty), the query has to use the hardness numbers from the 
aquarium table.  After the first fish is selected, then the combo needs 
to be filtered by the min/max query based on fish in the table, as well 
as inches.


-- 
John W. Colby