ShalomEguale
Qrew Trainee
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Help connecting Table to Table Relationships
Hi Laura, Thanks for your response. I need the Site Risk Register table because this is actually the main table that will be used. The Site Risk Register table has a form with questions users need to answer about the risks and milestones related to that site. So I plan to add the embedded link for both the risk and milestone reports in that form The Site table is a connected table from a different app and is only there so I can pull the Site ID#s to use as a lookup field. Ideally, that table will be hidden once everything is set up. Are you saying all the tables just need to have the same related field in order to be connected?Help connecting Table to Table Relationships
Hi, I have 4 tables Site table - houses all site info including site ID# which is the unique identifier to be used to relate/connect all tables. Risk table - houses all the risks. 1 site can have many risks Milestone table - Each risk can have many milestones Site Risk Register - Joining table that has all the risks and milestones relating to each site on one table I'm struggling to figure out how to connect these tables. I figured all tables need to have that site id# field in order to connect. So I created a one to many relationship with the Site table and the other 3 tables so all 3 tables have a site id# lookup field. Then I created more relationships. One Site Risk Register has many Risks, One Site Risk register has many Milestones and then I also made One risk table has many milestones. I added dummy data in the tables but it is not reflecting in the Risk Register join table. Can I get help on what I did wrong and how to properly set up these table relationshipsHow to consolidate multiple rows into one
Hello, Is there a way to consolidate multiple rows into one row? I have Table A right now. The Site ID column is the key column for the table since it’s a numeric field with unique values. I know about creating a relationship and then creating a summary field but I don't think it would work in this case because I want to use the Account ID column to summarize instead of the Site ID column. The only columns I'm interested in are the ones in the red square. Basically, I want to extract that data and consolidate it using the Account ID field and then have all the different Account codes related to the Account ID in one cell (like Table B). I don't mind if it has to be in a separate table. Is there a way to do this? Table A Table B
