Jump to content
Sign in to follow this  
jimpres

Find in a Portal Field

Recommended Posts

I have two files. Sites and Letters. The site file has fields with computer information in the fields. There is a Site Name field, System Type field, MaintExDate and a Computer Serial Number field. On site or "Site Name' could have 12 records (12 computers at that site).

The Letters file has a portal in it that has the related System Type, Compuer Serial and MaintExDate in it. The relationship is based on the unique site names.

So the Letters file displays a Site name and in the portal all the computer systems related to that site.

Based on the maintenance expiration date (MaintExDate) I want to only display in the portal those systems that have or will have in the next three months MaintExDate expired so I can send them a letter. I have tried to search the MaintExDate but if any of the dates are valid all the system serial numbers show up. I also tried omitting the valid dates but then all the records in the portal were omitted.

Is the answer to use a global with the date range in it and then find on the MaintExDate?

All help appreciated...

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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