Portal - Relationship Issue...
One of the DB's I've been working on for a while is finally ready to come online. However, I've just discovered I have a portal/relationship issue I don't understand. When I try to add new records to one table it creates unrelated records in another table. Since the data is sensitive I've created a simplified version of the problem area. The link is below.
The problem occurs when I update the Customer Profile with a Sales Staff Name and their Specialty. Instead of just associating it with the information that's already there, it creates a new record on the SalesStaff table. Too, the portal on the layout is supposed to show all the customers that each sales person has in the portal, not create a new record and also show multiple data per for each sales person. Clearly, there is something I'm not grasping, because no matter what I do, it just won't work.
If I could just see this simple portal working like I want it to, from all sides, I think the light might go on and I'd truly understand the whole portal concept.
Any help would be appreciated, even a link to another working example. Thanks.