e.g. I have 4 tables table1:applications fields: application_id, date_submitted
table2: users fields: user_id, department_id, date_created table3: applications_users fields: application_id, user_id table: departments fields: department_id, faculty, bldg, campus I want to link the tables applications, users and departments --- something like this from the docs---- For example, if we assume that 'post.Post' has a onetomany relationship to 'post.Comments', we could join all posts to their comments simply by using the script: from post.Post join post.Comments To continue that, if we wanted the Post joined with it's Comments and the User that created the Post, we could also have: from post.Post join post.Comment join user.User -------------------- The transfer.xml could be something like this? http://www.pastebin.ca/1409217 Also it seems it is NOT necessary to create XML entries for the "middle" table (in my tables above, it would be applications_users) in many-to-many relationships? Thank you very much :) Jayel ps. What does a collection (found in transfer.xml) do? I looked at the docs and the tblog sample app (specifically listpost.cfm) and it seems it's something I do not have to worry about if used? thanks again. --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
