⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Foreign key in grid view

Started by TechDaddies-Kevin, 01 June 2012 - 19:38 PM

Single Page

TechDaddies-Kevin

Member

Posted 01 June 2012 - 19:38 PM

Basic question here - I have a table called Programs with an ID and a Name column (Simplified, of course). I then have a table called Campus_Programs which has an ID and a Program_ID column. Program_ID refers to the ID column of the programs table.

In the grid view for Campus_Programs, I want to have a Name column which pulls the name from the Programs table. Is there any way to show joined tables in the grid view like I'm needing? I've gone over the API several times and just can't find that option.

Many thanks in advance.

TechDaddies-Kevin

Member

Posted 01 June 2012 - 19:42 PM

I'm an idiot and it's been a long day....Please forgive me.

This was amazingly simple to implement after I took a break. Man I love this software.