Hey, thanks for your thought. Sadly not all records contain all parameters. The data is actually event logs so no records are updated, just endless new ones created.

Thanks again.

Mark.

Hey,

thanks for your reply

To answer your question I need the IDs to enter new data that has previous entries. Maybe this is where I'm going wrong? If I use joins...