Automatically display all rows from a lookup

3

Hi @David_Boucard_Planel :grin: and Welcome to the Community :tada: !

Well, it’s not an issue per se, that’s just how LookUp fields work :wink:.

I have honestly no idea how to explain this as I really don’t have the technical language for this but by creating a lookup in your Table 2, you’re just give the ability to your Table 2 to get info from your Table 1.
It’s just a link between those 2 tables, nothing more.

To do what you want to do, you just need to go a little bit further and find a way to Filter() in your Table 2 the info you’re getting from your Table 1.

But I think @Saul_Garcia, explained it better than I could :wink: .

Another option (but seeing you tagged your post with “cross-doc”, I’m not sure this could work) could be to add a Button column to your Table 1 which, when pushed, could add the desired row to your Table 2.

In my example, [Projects (Lookup)] in Table 2 is still a Lookup field, so when adding a row, you wont loose the connection between the tables and still be able to get what you need from your Table 1 to your Table 2.

I also added a button on the canvas which will just push the needed buttons in Table 1 (so you hide the buttons in Table 1 and it will also tells you how many projects still need to be added to Table 2)

2 Likes