Hi,

can you please explain your situation a little bit more. How limited is your control over the database design? If you don't have unique ID how do you make the look-up?

I think you have many opportunities to solved your drawbacks, but I cannot suggest an alternative until I fully understand your scenario.

Kind Regards