Columns from Related Tables in Grid View?

Hello Good IJC People,





I have two tables -- call them A and B -- with a one-to-one relationship between them. In a grid view for A, is it possible to display the related field from B as an additional column (analogous to displaying a related field in the form view) without resorting to database chicanery? Or must I replace A with the augmented table from joining A and B to accomplish this??





Thanks,





- Ryan

No, currently the grid view can only contain data from a single table.


To display data from multiple tables you should use a form view. This can include a table widget for your "master" table and separate text widgets for the fields in your secondary table which should allow you to display the data you need.





Tim

Hi Tim,





O.K., thanks. We have aliases for compound registration numbers defined in separate table, and were hoping to display them alongside the real registration numbers in the grid view as well as in the form view.





Thanks again,





- Ryan

There is no direct way to do this just in the grid view.


We will be adding calculated fields to IJC in the future, which might allow you to do what you want.





In the meantime I think using a a form is your best solution.





Tim