Hi All again
i have a table that is pulled from a foxpro database, the table shows line items that have been ordered and the date that they are due (it_due), what i need to be able to do is keep a record of the first it_due date that was entered and any changes that are made to it after i would assume in seperate columns. There would never be more than 15 changes i am not sure if that is relevant.
below is the view i have at the moment
SELECT it_doc, it_quan, it_due