Error in Portal and Relationship!

[BluiSh]

Hello to everyone

I was working very well with my POS solution, I have the normal portal where all payments are made, this portal has a relationship where all the sales are saved, when I want to make a sale, go to the portal (all new and without data) and I start to add my products with my codebars reader, like all POS systems.

Well after making another relationships for other scripts suddenly when I go to my portal to make a new sale, a lot of rows appear from another sales made, this information is from the database that has the relationship in the portal.

I don´t know why this info is appearing after working very well. I tried and check a lot of things but nothing.

Someone could help me?

Thanks

BluiSh

[bcooney]

Sounds like you have a duplicate primary key in the Sale parent record. So, the "new" sale record comes in with an existing primary key, and you'll see the line items in your portal from the previous sale.

It would be helpful to know the tables that you have and how you have them related. Also, are your IDs unique, auto-entered serial numbers?

[BluiSh]

You are right, that was my error I was repeting the main key number, do you have any tip to avoid this kind of error???

Thanks again

Sincerely

BluiSh

[bcooney]

Do you know how you might have ended up with a duplicate primary key? If the key field isn't an auto-entered serial number, but rather something calculated, that would probably explain it.

Did you do an import recently? Perhaps you forgot to set the key to the next highest number?