Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

duplicating record mixes up log entries

hpw
in Relationships

Featured Replies

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.

thanks

hans

Contact_Log.pdf

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:

Companies

__kP_CompanyID

Name

Contacts

__kP_ContactID

_kF_CompanyID

Name_First

Name_Last

etc.

ContactLog

__kP_LogID

_kF_ContactID

Create an account or sign in to comment

https://fmforums.com/topic/53753-duplicating-record-mixes-up-log-entries/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.