Please look at this design.

[Jesus4u]

Please tell me if you think this is a good idea.

I am storing recurring orders in table A. However when the recurring orders are processed on a weekly basis I want to store the processed date in table B so that I can track all the processed dates for each recurring order.

Is this a good way to store the data?

Thanks

Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[donutman]

Table A (Order or RecurringOrder)
OrderID int
RecurringOrder bit [green]-- to differentiate between regular orders[/green]
OtherFields

Table B (OrderProcessDate)
OrderProcessDateID int
OrderID int
ProcessDate datetime

Yes, that would be a good structure, provided that there is only one entry for each recurring order in the Order table.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]