TABLE dbo.events
(
    EventID smallint NOT NULL,
    Eventname nvarchar(100) not null,
    Eventadded datetime NOT NULL,
    EventScheduled datetime NULL,
    EventDate datetime NULL,
    Department varchar(50) NULL,
    
CONSTRAINT PK_EventID PRIMARY...

Thanks for all help, will be testing, but this is headed in the right direction!

Hypothetically the orderid would also be copied from orders table to vendororders table sometime after the process of the order history

HTH, thanks

Thanks for the insights- i will have more of a detailed gameplan after re-testing the series of reports i have generated and could come back for more info.

Zo