# Need urgent help **URL:** \ **Category:** Ask for Help\ **Created:** [June 28, 2024, 1:00pm UTC](https://community.glideapps.com/t/need-urgent-help/74449 "2024-06-28T13:00:26Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [June 28, 2024, 1:00pm UTC](https://community.glideapps.com/t/need-urgent-help/74449/1 "2024-06-28T13:00:26Z")
Hi Guys, I have a unique requirement. Where I will create number of deliverables for a campaign in **deliverables table**. It can be one or many. Each campaigns will have different deliverables. Users apply to campaign, when they apply to campaign, I adding a new row in CampaignData table. where I am recording campaign name and user id of creator I have a table called Campaign content where I am storing campaign contents like url name etc. I have created a relation between my deliverable table and campaign data table such that it shows the list of deliverables for the campaign for the user. I am not able to understand how to click on the deliverable name listed and upload content for that deliverable, that creator and that campaign. Thank you in advance for help. **Basically for every creator based on the number of deliverables there for the campaign they should be able to upload content for each deliverable. N number of contents.** Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 29, 2024, 12:10am UTC](https://community.glideapps.com/t/need-urgent-help/74449/2 "2024-06-29T00:10:57Z")
So your sample data looks like this: ### Campaigns Table | CampaignID | CampaignName | CampaignDescription | | --- | --- | --- | | C001 | Campaign A | Description of Campaign A | ### Deliverables Table | DeliverableID | CampaignID | DeliverableName | | --- | --- | --- | | D001 | C001 | Deliverable 1 | | D002 | C001 | Deliverable 2 | ### CampaignData Table | CampaignDataID | CampaignID | UserID | ApplyDate | | --- | --- | --- | --- | | CD001 | C001 | U001 | 2024-06-29 10:00:00 | ### CampaignContent Table | ContentID | DeliverableID | UserID | ContentURL | ContentName | UploadDate | | --- | --- | --- | --- | --- | --- | | CT001 | D001 | U001 | [http://example.com/content1](http://example.com/content1) | Content 1 | 2024-06-29 12:00:00 | | CT002 | D002 | U001 | [http://example.com/content2](http://example.com/content2) | Content 2 | 2024-06-29 12:30:00 | Now, you want to know how one can upload content to a deliverable of a campaign. I believe if you construct your data as above, you already have all the pieces in place. A form in the deliverables details view would help you get the deliverable ID in place, the user ID is from the signed-in user’s profile, and the campaign ID can be taken from the deliverables relation (you don’t need to write this to a basic column). ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 1, 2024, 4:37am UTC](https://community.glideapps.com/t/need-urgent-help/74449/3 "2024-07-01T04:37:31Z")
Hi @ThinhDinh I played around with your solution. I am successfully able to create relation between Campaign and Deliverable ID and I am able to list All deliverables for the user. Meaning My relation column in CampaignDate table Lists the multiple deliverables **Now I am not able to think or understand how can I make a relationship such that when I upload a content it should upload to particular user → particular campaign → particular deliverable** I am stuck thinking on this relationship. Please forgive me if it sounds basic. Thank you in advance for your help. Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 1, 2024, 4:57am UTC](https://community.glideapps.com/t/need-urgent-help/74449/4 "2024-07-01T04:57:40Z")
Hi @ThinhDinh just tried creating a relationship. Now it’s uploading content from particular user to the deliverable from the campaign. But I am seeing a “?” symbol in my relation. ![Screenshot 2024-07-01 at 10.26.10 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b3a5c3c7e968b2e9b04dcf48859e4c9ad9fa85f6.png) I know its some error from my end. Could you kindly help me how do I solve it? Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 1, 2024, 12:13pm UTC](https://community.glideapps.com/t/need-urgent-help/74449/5 "2024-07-01T12:13:36Z")
Hi @ThinhDinh Thank you for your help I found the solution to have a perfect relationship to get my work done. I even got it to work on my Admin view as well. Regards, Dilip