New topic: Multicolumn combobox
<http://forums.realsoftware.com/viewtopic.php?t=45889> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message FCampos Post subject: Multicolumn comboboxPosted: Tue Nov 13, 2012 12:39 pm Joined: Tue Nov 13, 2012 11:19 am Posts: 1 Hi to everybody. I'm not sure if this is the right place to explain what I want. All my tables in my BD have an integer primary key and on other tables the related field to that PK, like this: Table: Colours Fields: IDColour; Colour Values: 1; Black 2; Red 3; Blue 4; White .. and so on Table: Person Fields: IDPerson; Name; FavColour Values: 1; Susan; 2 2; Peter; 3 3; John; 2 .. and so on If I make a form of table 'Persons' and want to put a combo to insert the colour in field 'FavColour' Is there a combobox that has two columns (IDColour, Colour) and shows only the column colour, but what I'm saving in my field is the first column? If this combo would have the these properties: DataSource: SELECT IDColour, Colour FROM Colours; DataField: FavColour 'The field of the table 'Persons' NumberOfColumns: 2 PrincipalColumn: 1 'The column that I want to save the value ColumnsWidth: 0px;60px '0 px IDColour, 60 px Colour. So only shows the second column I 'm new on RealBasic, so I don't know if there is a custom combobox like this, or close to it. Is there something like this? And will it work on Mac? Thank you. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
