[plum] Filtered Select Lists and IDs

[Marwan Saidi]

I have a table Models which includes the columns AreaID (an FK pointing back to the Areas Table), LowerPG (FK to the Pay Grade table) and UpperPG (another FK from Pay Grade). In the Plum IDE, the database info shows me my parent table relationships to the Models table, but when I generate forms, they automatically use the AreaID and PayGradeID (ints) rather than the Text label associated with each. This is expected, but in the tutorials it shows the parent items in the “columns not on this form” and suggests to swap out the ID column with the name column. However, those parent form columns are not in my form choosers. Does this make sense? What am I doing wrong? Thanks     Marwan Saidi American Eagle Information Systems 321.779.2577 - p 321.779.2576 - f