PDA

View Full Version : Fields from two different tables in one component


ABC123

Howard G. Cornett
09-13-2004, 11:31 AM
Is it possible to display fields from two different tables in the same grid component? If so, how? I have a desktop app where this situation exists and I need to know how to convert it to the browswer-based database model.

Thanks,
Howard

Selwyn Rabins
09-13-2004, 01:00 PM
there has to be some type of relationship between the tables that the fields come from.

but assuming that there is a relationship, then the answer is yes. instead of basing the grid on a 'table' you base it on a 'view' (which joins two or more tables).

the sample apps that ship with alpha five show examples of this. there is one grid that is based on invoice_header and customers and another grid that is based on invoice-items and products.