Hello, I would like to have the possibility to link from one record to other records in many other tables, something like this:
in table dates: id = 1 when = 2007-07-04 14:00 ... some more fields a mapping table would look like this: date_id = 1 link_id = 5 link_table = customers date_id = 1 link_id = 29 link_table = employees This would define a date between a customer with id 5 and an employee with id 29. I could also book rooms with the same scheme, organize staff meetings and whatever comes to mind. The only problem is, I don't know how to define such a mapping in RDBO. Do I have to somehow (how?) define every possible table that can be linked to or is it possible to say "take whatever is in link_table" to be a table name? Any ideas? Thanks Michael ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object