New topic: SQL/multi-column Combobox and Selection/Updating Issues
<http://forums.realsoftware.com/viewtopic.php?t=45154> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message b.l.allen Post subject: SQL/multi-column Combobox and Selection/Updating IssuesPosted: Tue Aug 28, 2012 12:26 pm Joined: Fri Aug 10, 2012 6:40 pm Posts: 3 Location: SW Oklahoma This one is quite a challenge. Here goes: I have a RealSQL dB that has several tables. Among the tables there is an Item and a Supplier Table. The primary keys are doublecolumns that store a unique key for each record. The Item Screen (uses the Item table) displays a key to the Supplier Table. What I need to do is instead of the user looking at the Supplier key which means nothing to them, I want them to see the Supplier name instead. They can pick the supplier name they want out of the combobox list but it will actually store the supplier key, not the name. I want this to be behind the scenes and the user won't see a thing. Also, I'm loading the combobox with the supplier name/key like this: Supplier Name:10019235 My thought was when the user selected the row out of the combobox for the supplier they wanted, I'd just strip off the key at the end to store in the database. I guess I've gotten myself confused on how best to accomplish this. Hope I've explained the issue adequately. If anyone has any ideas, I'd be appreciative. Thanks, BL 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]
