You are welcome.

You should be receiving the e-mail shortly.

-Ray

Hi Bob (John_Y_Cannuck),

You will want to have your files merged together in Sesame.
Design them the way you want them to be designed.
Then have the student go through and add the Code values.
Then link the child databases up to the parent database.

-Ray

Working my way throught the data bases. The full size lot owner database took over an hour to convert from Qa4.

Now I'm working on programming problems, i'm almost done  I think, but I have one I can't solve.

If selection = "1" then fieldname1 = fieldname2; If selection...
it's a long statement with 8 possible selections.
The error message says it's expecting a boolean expression. I'm lost as to where to look for anything that might draw a boolean.
Ideas?

IF SELECTION = "1" THEN Flower_Charges = GER,BEG; IF SELECTION = "1" THEN Flower_Charges = GER,BEG; IF SELECTION = "2" THEN Flower_Charges = GER,ALY; IF SELECTION = "3" THEN Flower_Charges = BEG,ALY; IF SELECTION = "4" THEN Flower_Charges = PET,ALY; IF SELECTION = "5" THEN Flower_Charges = IMP,ONLY; IF SELECTION = "" THEN Flower_Charges = 0.00; IF SELECTION = "7" THEN Flower_Charges = GER,ALY; IF SELECTION = "8" THEN Flower_Charges = GER,ONLY; IF SELECTION = "9" THEN Flower_Charges = BEG,ONLY; if SELECTION = "6" then Flower_Charges = "0.00" and Planting_Charge1 = "0.00";

You need to change the last line to

If SELECTION = "6" then
{
	Flower_Charges = "0.00"
	Planting_Charge1 = "0.00"
}
 

     

Ok, now as I'm importing some of the other databases, I get a message telling me there are duplicate reports. I checked, and yes there are. So, I am currently trying to delete some of them. I can't find a referance to this in the manual.  How do you delete a report?

Well, that was embarrasing  sorry.