Jump to content
Sign in to follow this  
digidiva

multiple finds: portals and fields

Recommended Posts

I need to search 2 sources for a single found set: source one is a field called : initialappttime, the second source is a field in a related database called followupapptime. I need the search result of both of these sources to appear in one place, layout: dailyschedule, in a columnar report.

I am making speghetti of my script.

Thank you for your assistance.

Share this post


Link to post
Share on other sites

I don’t like searches across files, but if we have to do it then we do it….

But I don’t understand why you are having a problem with this. Go to the layout you want to display the results in, enter find mode, enter the values in the fields you want to search and perform the find. All you need are the fields from the local file on the layout, and the fields from the other file on the layout using a relationship/portal.

If I’ve missed the point here, you need to explain your problem a bit better.

Rigsby

Share this post


Link to post
Share on other sites

the problem restated:

I have a relational database. One of the layouts in the MAIN DB is called DailySch. On this layout I need to enter ONE search date in ONE search field, ex 10/6/01, then, I need that search date to look in TWO places for the results: the first place is in the MAIN DB in a field called "initialAppt", the second place is in the MAIN DB in a field called "recentAppt", where "recentAppt" is already in a Portal from the related database "FAppts"...the Portal contains fields ::FollowDate ::FollowTime, this layout autosorts for the most recent occurance to appear at the top.

NOTE: the related database Fappts stores all of the occurances of RecentApps, RecentTime, etc...

I would like to search the database to have ALL occurances of a single search date from 2 sources appear in a single columnar report.In that columnar report, I need to have displayed, based on the search criteria

Date of appt, time of appt, Fname, Lname, Rvisit

I want to hit 2 birds with one stone, and both birds have the same color, but are in 2 different bird cages.

Since the end user needs this ASAP (As Simple As Possible), entering data into one field to get information from 2 sources is the easiest.

I hope this additional information is clarifing. Again, thank you for your input and solutions.

Share this post


Link to post
Share on other sites

The fast and easy way to do this IF your are always searching for a single date and not a range of dates (actually, you can do this too with more complexity) is to use relationships instead of finds.

In your main file create a self relationship between a global date field, "gFindDate" and the "initialAppt" field. Create a relationship to the other file between gFindDate and the "recentAppt" field. The record or records in the other file will be available as soon as you enter into gFindDate. In the current file, you can either display the fields of the desired record as related fields (both sets of data will pop up as soon as your enter gFindDate) or use the script step "Go to Related Record" to isolate the record in the main file.

-bd

Share this post


Link to post
Share on other sites

I tried it an could not make it work. The global field just showed whatever date I typed...the find did not find any thing. Am I missing something here?

enter search date xx/xx/xx, look in 2 places (field 1 in main database, field 2 in either: main database portal or different related database), show results in columnar report...

Share this post


Link to post
Share on other sites

the search criteria will ALWAYS be a SINGLE DATE, not a range. I will implement your suggestion and let you know my results.

thank you for your assistance with my speghetti dinner!!

Share this post


Link to post
Share on other sites

Remember, to simulate a "find" in the same file, you must execute a "Go to Related Record" script step after entering the date. For finds in the related file, you must display the related fields. Oh, lastly, you must exit the global field to see the changes in related data. Did you create all the relationships properly?

-bd

Share this post


Link to post
Share on other sites

Yes, I did create the relationship correctly. I suppose I need to revisit my problem. What I want to do seems so simple.

Search A and B place results C

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    aztrix55 
×
×
  • Create New...

Important Information

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