View Full Version : Can you create a business table which is based on 2 physical tables?

03-03-2008, 08:08 AM

I have a table, and another table which looks up a status value for the first.

I want to create a business table which has the text of the status value from the status table, and the details from the parent table.
i.e. I want to hide the ID value.

Can metadata do this kind of thing? If not then I guess you have to build views in the database and base the metadata off those?


03-03-2008, 08:48 AM
Dan, you can obviously choose which columns to show to your end-users. (in the categories editor)
There is even a "hidden" property (boolean) that allows you to inherit these things from a parent Concept.


03-03-2008, 08:52 AM
Oh i see! so you just create the tables individually then hide the ID fields.

In fact i've just seen the difference between business views and tables, and i see how it works now, it all looks good. so i'm going to publish my basic model now and see how that works with the waqr.


Excellent thanks.

03-03-2008, 10:31 AM
Ok, so that does work - so i have my parent table, the child table, and rather than showing the ID's that link them, I can allow the user to just select the descriptive name from the child table.

However, I would still probably want to combine them into one table. This is because for one parent table we may have 5 or 6 separate lookups to these style of child tables. That wouldnt work nicely in the waqr because it would display each one as a separate group.

Does that make sense? Clearly i can very easily do this with a database view, but I hoped there would be no need to do that as this is additional maintenance.

03-03-2008, 12:51 PM
WAQR should show the categories, not the business tables.

You can add a business column to any of the categories you created.


03-04-2008, 04:22 AM
Ah i see, I have to use the manage categories window - it wasnt clear this was how to do it. good.