Question????

In the Database designer, I am attempting to set a Many-to-one relationship between two tables. I have two tables, order_items and products. In order_items I have the follwing indexes; (productid(regular), orderid(regular), & orderdetid(regular)). In products I have the following indexes set; (discontd(regular), categoryid(regular), serialnum(regular), supplierid(candidate), productid(candidate)). I have attempted to do a many-to-one relationship order items to products useing productid as the linking index tag. It won't allow that. 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.

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?

Any help would be appreciated.