>Question????
>
>In the Database designer, I am attempting to set a Many-to-one relationship between two tables. [snip] It will let me do a one to many from products to order_items but no many to on the other way. Might that be the same thing? I am thinking it is, but just want some confirmation on this.
>

Same thing. I find it less confusing to always think of it as one-to-many.

>I also have another quick one. From the Database Designer, if you go up to the menu bar and select Database---Cleanup Database but Cleanup Databse is greyed out does that mean your database is OK and doesn't need to be cleaned up?

It means the DBC wasn't OPENed EXCLUSIVE.
The database must be opened exclusively for it to be cleaned up, because it calls PACK DATABASE.