Got it thanks!!!!

I looked over your response but i still can't get it to work. I'm using access so the innerjoin syntax is a little different than the syntax that you showed....

The union makes perfect sense to me! .. the only thing i don't understand is how this data warehouse is any different than the...

How did you reference the appended tables when you needed historical changed data?

As far as the zip codes go, i was thinking of backwards compatibility on the application side....

Thanks again for getting back to me so quickly. Again, because i'm new to triggers and sql server itself, its kinda hard to follow exactly how your trigger is sending...

http://www.datamodel.org/

a sample of that membership database with the address issue i was talking about. Is there a way to plug into a program or interface API to keep zip...

Wow... exactly what i had mind. My only question on this would be.. would it make sense to use a foreign key and show a relationship between the log and...