⚠ 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. ⚠

  •     

profile picture

How to pull and edit data from multiple tables



michaelh613

michaelh613
  • profile picture
  • Member

Posted 10 August 2015 - 17:53 PM

I have two table I want to edit data from. 

It looks like I can't use set_relation because I don't the primary key of my second table is not a foreign key for my first table. 
It's a simply id field that isn't related to my primary field I am editing.

The two tables do have a 1-n relationship based on non primary key fields in the second table.

Is there way to display and edit data from the second table at the same time.  It would be a pretty basic sql query outside of grocery crud.  I'm trying to think how to do this without editing core files