Popluating & Changing information using Primary Key PJK_TLA 21.07.2006 00:58:01 Heya Folks, I'm having difficulty with being able to change items that are related to a Primary Key. Example of situation: Tbl:Organizations Flds:Organization Name, Address, etc. Tbl:Contact Person Flds:UserID,First Name, Last Name, etc. Now my Organization Table has a fld that is Contact Person ID. For this case assuming each organizaiton can only have one contact person but the idea is that Contact Person can belong to multiple Organizations. The two tables are linked with the User_ID Being the primary key in the Contact Person Table. Now when I create an infopath My main database connection is to the Organizational Table with the Contact person table being a Sub-section. When I query an organization That organization and their Contact person's data fills the field. When I create a new Organization and enter the User ID of an already existing User it populates everything and it's great. Now this is where my difficulty comes in. If an Organization changes Contact persons infopath won't let me do this. Here's what I've tried. I query the Organization and it comes up. I change the UserID to someone else that already exists in the ContactPerson table. I do this in the Organization table (Not the User section) I hit submit. Infopath says I can't do this because I'm changing the UserID which I'm not trying to do. Other option, I query the Organization and it comes up. I right-click the User section and "Remove this User". I enter a UserID of someone who exist. I submit. Everything seemse okay, this new User ID is associate with this Organization. BUT I check my Table:Contact Persons. And that UserID&Contactperson and information has been deleted from the table! I hope this explain my problem. I want to be able to change a Joined information by adjusting by changing the IDUser in the NON-primary Key section to populate the table where it Is a Primary Key. Thanks!