i'm just bumping my own post, as for some reason it never came through via email... still wondering how to do a "join" on fields for the show.dryml page, but not on the index.dryml page, where i'm using table-plus.
thanks, andrew On Dec 23, 10:29 am, andrew hill <[email protected]> wrote: > hi folks, > > i'm trying to figure out how to display different data on the show record > page than the table display / search page. > e.g. i've got a model called "guitar" that produces an output like this when > i list / search on it: > > Guitar Model Color Tremolo Fingerboard Pickguard Tuners Phase > Switch Studio Switch Armrest Notes > 00001 ROC WHT MPL BPG OST > > 00002 AV TEAL MPL OST > > 00003 ROC TUR RW WPG OST ARM > > those two or three-letter codes are "factory" codes in my guitar database > table, and i'd like to leave them be, so people can search using a combo of > standard codes. > > i've got another table/model called "factorycodes" which only has 2 columns, > one with the 3-letter code, and the other with a plain english translation > (e.g. WHT is White) > > when i click on the guitar serial number under the "Guitar" column, though, > i'd like to do some sort of join so that the individual record listing > replaces the column values with ones from the other table, e.g. modify this > below: > > 00001 > > Serial 00001 > Model ROC > Color WHT > Tremolo > Fingerboard MPL > Pickguard BPG > Tuners OST > Phase Switch > Studio Switch > Armrest > Options1 EMG > Options2 > Options3 > Made In USA > Made On (Not Available) > Notes > anyone have a suggestion how to do this? i've been trying various "through" > syntax but not 100% sure what i'm doing, as i can only seem to break the > lookups :) > > best, > andrew -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
