Hello,
I have a curious issue that I hope someone can offer some advice on.
I'm working with several related tables. When I go to the related field tab under a topic, and select "Add an existing <table> record", Xataface builds a dropdown box of those existing related fields that I can choose from. My dropdown box is being populated with the 'creator' field of that existing record. I would prefer that it be created with the 'number' field. The weird thing I noticed was that if I change the 'number' field to be varchar instead of int, then it populates correctly. Is this expected behavior? Can I control how that dropdown gets populated? How does Xataface figure out which field is used to populate that dropdown box?
This is the table I'm working with. Pretty simple stuff.
CREATE TABLE `letters` (
`letter_id` int(11) NOT NULL auto_increment,
`number` int(6) NOT NULL,
`description` text NOT NULL,
`creator` varchar(10) default NULL,
`date_created` datetime default NULL,
`date_modified` datetime default NULL,
PRIMARY KEY (`special_letter_id`),
UNIQUE KEY `number` (`number`)
)
Thanks,
Jay