Portal should display records from a range of date

[coldspring]

I am really stumped on this one...perhaps it is too late in the evening. I have successfully implemented the technique that will allow a user to enter a range of dates from a parent and then display all of the records in the child.

I need to specify a date in the parent (say 3/10/2004) and then display all of the records from the child where Field1, Field2, Field3 or Field4 match that date. Any ideas? Thanks

[CyborgSam]

Use the multiple-key relationship technique, where a relationship is made between two text fields, where one or both contain paragraph mark delimited values (multiple lines of text).

For your case: in the Parent, make a text calculation field c.Date.Text with DateToText( theDate )

In the child, make a text calculation field c.Fields.Text, substitute the paragraph marker in the calculation window for PM (leave paragraph marker in quotes):

DateToText(Field1) & "PM" & DateToText(Field1) & "PM" & ...

In parent: define a relationship between c.Date.Text and c.Fields.Text.