Help Needed

[sudhakar]

Dear Friends

I am a new to Xataface and I want to combine the two table and want to show in one view / edit / delete

Please tell me that one is possible or not in Xataface.

My table name "profile_categories" and "profile_categories_description" and my structure are shown below

Code: Select all

CREATE TABLE IF NOT EXISTS `profile_categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_image` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
)

CREATE TABLE IF NOT EXISTS `profile_categories_description` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
)

Thanks for your advanced help!.

[shannah]

Looks like you have a one-to-many relationship here between the profile_categories and profile_categories_description. The way that I would set this up, if you want it all on one form is to set up a relationship from profile_categories to profile_categories_description. Then use the grid widget to be able to add/remove languages to a profile_category on the profile_category edit form.

[sudhakar]

Thanks for your reply. do you have any sample code for that one.