⚠ 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

Add custom fields to form



cargonsan
  • profile picture
  • Member

Posted 02 January 2013 - 12:26 PM

Hi,

I'm newbie in grocery CRUD and i have a question.

I have three tables, one only for languages, whith the following structure:

`id` int(11) NOT NULL AUTO_INCREMENT,
`language` char(32) COLLATE utf8_bin NOT NULL,
`code` varchar(2) COLLATE utf8_bin NOT NULL,
`enabled` int(11) NOT NULL DEFAULT '1',
`default` tinyint(4) NOT NULL DEFAULT '0',

another table, named translations:

`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(64) COLLATE utf8_bin NOT NULL,
`translation` text COLLATE utf8_bin NOT NULL,
`language_id` int(11) NOT NULL,

this table has a relationship with languages language_id==id

And the third, named board:

`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) COLLATE utf8_bin NOT NULL,
`tag` varchar(64) COLLATE utf8_bin NOT NULL,
`photo` varchar(64) COLLATE utf8_bin NOT NULL,
`order` int(11) NOT NULL DEFAULT '0',

that has a relationship with translations table with the tag field.

Actually i only have two languages, Spanish and English.

My question is:

Is it possible to put the two description fields (English and Spanish) in the add form. I dont know how to set the relationship between this two tables and show this fields in the form.

Thanks and sorry for my english