Newbie Questions

Re: One Form viewing Two Lists Relationally

EArgen — Mon, 19 May 2014 13:33:13 GMT

So I figured out how to make it not appear missing. It had to do with the way my tables were set up. I had an Address ID with Identity as the Primary Key.

Instead I changed it to EMP_IDFK without identity, and used it as a foreign key to the first table's primary key. This allows it to generate in the correct order and show if there is missing data.

HOWEVER

When there IS missing data, for example if B3 was never added to the system, I still cannot edit those fields. Once I figure out how to do that, or if anyone can help figure that part out, I think I'll be set.

As a note, I do not have a web service set up just yet, I'm only querying directly to the SQL Server just to try and get things to work. I don't know if that would fix the problem of editing that field or not, but as it is I can edit the other fields just fine (just can't submit obviously.)

Re: One Form viewing Two Lists Relationally

EArgen — Fri, 16 May 2014 20:49:23 GMT

jun_barbosa:
Hi EArgen, Did you create fields in your main data source? You can create fields in your main data source and get the values from your secondary data source List A and then display the correct values from List B using filters. Let me know if this works or if you need more help. Jun

I think it has to do with the way I want the data to look.

Basically I have the following from table A and table B, all fields are repeating so they go like this:

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 B3 B3 B3

However, if the second table doesn't have information in it for someone, that row disappears.

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 Missing!

Worse yet, if a fourth person is added, their address info is where the last person's address info should be:

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 B4 B4 B4

A4 A4

So now not only can I not see where person 3's information is, I can mistake person 4's info for theirs. I feel like this is a very basic fix but I can't for the life of me figure it out. The same happens with non-repeating tables, except that when the person is missing all info from the second table it's simply greyed out and I can't alter it at all.

Re: One Form viewing Two Lists Relationally

jun_barbosa — Fri, 16 May 2014 03:15:05 GMT

Hi EArgen, Did you create fields in your main data source? You can create fields in your main data source and get the values from your secondary data source List A and then display the correct values from List B using filters. Let me know if this works or if you need more help. Jun

One Form viewing Two Lists Relationally

EArgen — Tue, 13 May 2014 14:52:37 GMT

Hi everyone, I am new to InfoPath and this is probably a very simple thing to do, but I just can't seem to get it to work. For reference I am using SharePoint 2013 along with InfoPath 2013.

My question is this:

I have a list A that has basic employee information (EMP ID, First Name, Last Name) and list B that has basic address information (Address ID, EMP ID FK, Address, City, State, ZIP). The 'EMP ID FK' is the foreign key I am using from List A to form the relationship between the lists.

In InfoPath, I want to be able to list out this information in a row with split columns, so you can see all of the information like this (EMP ID, First Name, Last Name, Address, City, State, ZIP), for however many people there are in the system. I can get the repeating part to work, I make the data connection and just click and drag over. But I don't know how to match the information. I want EMP ID 1 to be matched with EMP ID FK 1, and EMP ID 3 to be matched with EMP ID FK 3.

I have tried 'hiding' the control if EMP ID does not equal EMP ID FK, but that just hides the control entirely, not what I'm looking for.

Am I just going about this the wrong way or is this more complicated than I think it is? I would prefer a codeless solution, but am willing to work with code if you are kind enough to explain it.

Thanks for your help!