# Cant solve a problem

**URL:** https://community.glideapps.com/t/cant-solve-a-problem/74332
**Category:** Ask for Help
**Created:** [June 23, 2024, 4:05pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332 "2024-06-23T16:05:35Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Remy\_BONNIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remy_bonnin/32/76895_2.png) [@Remy\_BONNIN](https://community.glideapps.com/u/Remy_BONNIN)
#### Post date: [June 23, 2024, 4:05pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/1 "2024-06-23T16:05:36Z")

</div>

I have a table with projects and another with contacts.  
Each project can have one or more contacts.  
So, I created a contact sheet (IDFiche, IDProject, IDContact).  
When I access the project sheet, I want to display the contact(s) related to this project, but I can only display the IDs and cannot find out how to add the contacts linked to the project.

 ![Capture d'écran 2024-06-23 182706](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9910f8bf942ec525584911a2e1318f99ec658ba.png)

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [June 23, 2024, 4:42pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/2 "2024-06-23T16:42:15Z")

</div>

You can use filters on your collection components by setting: IDProject is screen \> IDProject.

---

<div class="post-metadata">

### Author: ![Remy\_BONNIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remy_bonnin/32/76895_2.png) [@Remy\_BONNIN](https://community.glideapps.com/u/Remy_BONNIN)
#### Post date: [June 23, 2024, 4:51pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/3 "2024-06-23T16:51:46Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/587bd67bd2c581c0a74b26be6649e8ef84de5101.png)  
Already done… but i can t access to fields (name, function, company…)

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [June 23, 2024, 4:55pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/4 "2024-06-23T16:55:54Z")

</div>

> [@Remy\_BONNIN](#):
>
> but i can t access to fields (name, function, company…)

What do you mean? Isn’t your collection able to display contact data related to your project? If you click on your collection you can create further details in your contact sheet.

---

<div class="post-metadata">

### Author: ![Remy\_BONNIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remy_bonnin/32/76895_2.png) [@Remy\_BONNIN](https://community.glideapps.com/u/Remy_BONNIN)
#### Post date: [June 23, 2024, 5:11pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/5 "2024-06-23T17:11:05Z")

</div>

I create my table like this

Table Projet : IDProjet , ProjetName, Etc  
Table contact : IDContact, Name, etc…  
FicheContact : IDFIche, IDProjet, IDContact

In Red : it s Fiche Contact data with filter IDProjet = Screen.IDprojet

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c66706639a99eb1ed740e456aed35fa6ab1e72da.png)

I don t find a way to show contacts data directely on this page… i miss something

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 23, 2024, 5:14pm UTC](https://community.glideapps.com/t/cant-solve-a-problem/74332/6 "2024-06-23T17:14:09Z")

</div>

Add a relation column that matches the ContactID with the same value in your Contacts table, then use lookups through that relation to pull in the values that you need for display.