public productForm( mainForm parentForm )
		{
			//
			// Required for Windows Form Designer support
			//
			InitializeComponent();

			//set up the odbc connection reference
			this.MdiParent = parentForm;
			this.odbcConnection = parentForm.loginData.odbcConnection;

			try
			{
				//grab a list of product categories from the database.
				OdbcDataReader odbcResult;
				OdbcCommand odbcCommand = new OdbcCommand( "", this.odbcConnection );
				odbcCommand.CommandText = "SELECT categories.*, categories_description.* FROM categories INNER JOIN categories_description on categories.categories_id=categories_description.categories_id where categories.parent_id=0";
				
				odbcResult = odbcCommand.ExecuteReader( );
				while( odbcResult.Read( ))
				{
					ListBox newItem = new ListBox( );
					newItem.Text = odbcResult.GetString( 8 );
					this.categoryList.Items.Add( newItem );
					this._RecurseListCategories( odbcResult.GetInt32( 0 ).ToString( ), odbcResult.GetString( 8 ), 
						this.odbcConnection );
				}
			}

			catch ( OdbcException ex )
			{
				//database error, handle it now...
				for( int i = 0; i < ex.Errors.Count; i++ )
					MessageBox.Show( ex.Errors[i].Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error );
			}

			finally
			{
				//update our current catergory list no matter what
				this.categoryList.Update( );
			}
		}

		/// <summary>
		/// Recursively find category listings
		/// </summary>
		/// <param name="parentID">Current listing (will find children)</param>
		private void _RecurseListCategories( string parentID, string currentName, OdbcConnection connection )
		{
			OdbcDataReader odbcResult;
			OdbcCommand odbcCommand = new OdbcCommand( "", this.odbcConnection );
			odbcCommand.CommandText = "SELECT categories.*, categories_description.* FROM categories INNER JOIN categories_description on categories.categories_id=categories_description.categories_id where categories.parent_id=" + parentID;
				
			odbcResult = odbcCommand.ExecuteReader( );
			while( odbcResult.Read( ))
			{
				ListBox newItem = new ListBox( );
				newItem.Text = currentName + " : " + odbcResult.GetString( 8 );
				this.categoryList.Items.Add( newItem );
				this._RecurseListCategories( odbcResult.GetInt32( 0 ).ToString( ), 
					currentName + " : " + odbcResult.GetString( 8 ), this.odbcConnection );
			}
		}

OdbcCommand odbc_Second_Command = new OdbcCommand("");
odbc_Second_Command.CommandText = "SELECT"...;