Are you sure your primary and foreign keys are not mixed up? Can you post the script that imports the data?
It is hard to make any suggestions without seeing the script that transfers the data
Some more details worth checking and reporting:
It would also help to know what your key fields contain and how they are populated -- both primary and foreign keys.
Also, have you done any imports or other activities which might allow the addition of duplicate Keys.
And, do you you have any "duplicate" options enabled for recoreds in any tables? If so, are the primary Key fields set to always generate new numbers even if the record is simply duplicated?
Hi, Sorry for the delay. I am out of town teaching a class right now and won't be back until next week... Some of these questions are out of my realm of knowledge like primary & foreign keys... As for the seeing the script, it is multiple scripts that makes it work and I am not sure how to copy all of this information over so that you can see it all... However I have the abilities to let you login to my system and see the codes for yourself if that would help. Let me know what is best and I will work to get you the info that you need to help me.
One other thing yes I did an export of my information by way of excel and imported it back in... Could this be the issue? If so what would I need to do to fix this? I have done this type of export many times before and have never had this happen.
I hope you are not teaching FIleMaker...