Create 'New Arrivals' Table with Foreign Key?

[ne_plus_ultra]

I am finalizing my database using MySQL query browser. I have the following tables in place:

- Groups
- Visitors
- Countries
- States/Provinces
- Categories
- Products
- Orders
- Order Details
- Order Status

I would like to be able to query a New Arrival RecordSet. This is for new products that are added to my database each month - they will display on the cart home page. Does anyone have any suggestions on how to structure this...

I assume I start with a new arrivals table and somehow link to products table? Could I insert a new column in the Products table for new arrival (yes,no)? And then link the 'Yes' products.

Is there a simpler way to do this?

Regards,

[chazzy]

does the products table have a "created date" column or anything similar? i'm assuming that you'd want to update this periodically during the month, maybe you could create a view (assuming you're using mysql 5+) that just looked at the products that were created this month?