Alternatives to portals

[john12pm]

We have a 1:many relationship set up within a database. Is there anyway to associate multiple child records to one parent without using a portal? We want to be able to take advantage of the sliding functionality for the child records as they are of varying lengths but understand that sliding does not work within a portal. Suggestions?

[Ocean West]

I assume this is for a "report", for printing... you can use a "utility" table first grab all the data from fields from each child table store it in $variables, or return separated $variables create the necessary number of records in this utility table setting the fields to values you grabbed earlier, then you should be able to then use the sliding objects, when you print. Then just delete the records when done with the report.

If you are using a truly unique serial number such as Ray's Base36 http://www.nightwing.com.au/FileMaker/demos9/demo910.html you could just grab all the IDs from each table in to a return separated list. Then do as I suggested above

you can then in a looping script create a new record for each item in the list using GetValue() then your fields could use auto enter by calculation getting the data from the the ID field to each of the related tables.

[Ocean West]

here is an example...

DeNormalize.fp7.zip

[john12pm]

Thanks for the help