P
PJK_TLA
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!
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!