You are right... The way IdeaBlade handle relations is excellent! The only concerns is that I have to interface with others tools in order to use their presentations tools for reports and so on...An they require just a single table with all the data. So if I have the Employee data and their related data, I would need to be able to copy all this data into just one table...

 

Thanks

 

Developers who are new to DevForce often find it hard to shake old habits and prejudices.  For example, many developers ask us how to create a join of one table with some related tables.  We try to show these developers that joins are quite unnecessary.  Just use the tables as they are and use relations to get the related information.  There are many examples in the tutorials that use complex and interrelated tables, and nowhere do we do any table joins.

 

The question that I would ask you is why do you want to put the data in a single table. For example, to get the Employee's Address, we use a relation.  We use "Employee.Address" and two tables, an Employee table and an Address table.  I think what you want is one table, i.e., an Employee table with an added Address Column.  Note, however, that we still use the same expression to get the Address, i.e., "Employee.Address" so we haven't made it any easier for the developer to write his code, and meanwhile we've added more work for the DBA.  Someone has to create the joined table.

 

I would need to create a new DataTable with all datamembers from the Employee class (IdeaBlade Tutorial Database). I mean, just a single table with the employee table data and the related entities , such the home address. It is possible? How to do it?

 

Thanks in Advance!

Gus