Newbies tewan Posted March 25, 2006 Newbies Posted March 25, 2006 Does anyone know a way to export records from a portal and the related record from the parent file WITHOUT creating breaks in the report? For example, I get this on output: record 1 portal field 1 portal field 2 portal field 3 record 2 portal field 1 portal field 2 and what I want is: record 1 portal field 1 record 1 portal field 2 record 1 portal field 3 record 2 portal field 1 record 2 portal field 2 The main related record is exported with every portal row occurance. Thanks!
Genx Posted March 25, 2006 Posted March 25, 2006 Make a script to goto all the related records in your foundset... Show these related records in a layout linked to your portal table occurance, and export from there... ~Genx
Newbies tewan Posted March 27, 2006 Author Newbies Posted March 27, 2006 (edited) I'm talking about exporting. Also, this is a many-to-many relationship where I have all the records in the main table relating to all the records in the 2nd table. There is no 'direct' relationship between the two tables. I've used the 'X' relationship type. Example: Record 1 (Main table) relates to all records in the 2nd table. Record 2 (Main table) relates to all records in the 2nd table also. So, using real data.... 8000 relates to 1010, 2021, 330, 432, etc...... 8010 relates to 1010, 2021, 330, 432, etc...... When I export from the portal, I get this (the main table record acts as a break record, and I want it listed on every line) 8000 1010 2021 330 432 8010 1010 2021 330 432 and I want...... 8000 1010 8000 2021 8000 330 8000 432 8010 1010 8010 2021 8010 330 8010 432 Edited March 27, 2006 by Guest
dysong3 Posted April 21, 2006 Posted April 21, 2006 Hi tewan, I have exactly the same problem and have not yet found the answer. If you have any news on this I would be very grateful if you could post it. I, of course, shall do the same.
Ender Posted April 21, 2006 Posted April 21, 2006 Follow Genx first response. That should work for the typical one to many or many to many relationship.
dysong3 Posted April 22, 2006 Posted April 22, 2006 Thanks for that Ender, However that only half resolves the issue. I am trying to export contact data to later import it into my palm address book. As my telephone numbers and email addresses are in related tables, using this technique manages to keep the phone numbers and emails that are related linked to their other specific data. The problem however is that this technique also creates a new record for every instance in a phone number and an email in a related table exists and this data is totally superfluous. Worse than that it doubles, triples or qudruples the phone information creating otherwise empty records. This is what I need to know how to avoid. I have an inkling that using "group by" for exporting, or XML or XSL would resolve this issue, but I can't manage to get any of these to work.
dysong3 Posted April 22, 2006 Posted April 22, 2006 Just answering my own post here. Sorry to be a dummy. I just succeeded in "grouping" the export using the serial number and this has resolved the issue. Hope this helps someone.
Recommended Posts
This topic is 6790 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now