Jump to content

Portal should display records from a range of date


coldspring
 Share

This topic is 6521 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6521 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.