Jump to content
Sign in to follow this  

duplicating record mixes up log entries

Recommended Posts

Hi there!

I have a contact db with a contact table and a related contactLog table.

Now I wanted to duplicate a record as I had a new contact (Let's say: Mr. Smith) related to the same company with the same address as another one (let's say: Mr. Miller) I already had in files and changed only the name and phone number.

Well, now I started to make entries in the log to Mr. Smith's data and afterwards I got the shock: The same Log entry I made for Mr. Smith was also added to the Log of Mr. Miller.

How can I resolve that bug? I attach the relationship graph of the two tables in question.




Share this post

Link to post
Share on other sites

Sounds like you are also duplicating the key field in the Contacts table, so it sees the related Log entry as well.

It also sounds like your data model is all wrong. You should have three tables, at least:













Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.