Jump to content

C = A + B script needs help


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

Recommended Posts

I need to execute a script that does this:

Enter search criteria in field C, have the find look in field A and field B for the results, have the results posted as a columnar report in Field C

WHERE: Field A and B are a date fields, result C is a date field

WHERE: Field A is in main database, Field B is in another database, result Field C is in main database

If needed, the search criteria can be entered into new field D, where results from A and B are displayed in C

In all instances, only a single date will be searched, not a range. The results from both field A and Field B MUST be displayed in field C

Thank you.

Link to comment
Share on other sites

The find you want to perform is easy, you just need to answer one question: Do you want to find all records where both fields match, or all records where one of the fields match?

Both fields must match = your script will:

Enter find mode

Go to field C

Wait for user to enter date

Set field A to field C

Set field B to field C

Set field C to empty

Perform search

One field must match = your script will:

Enter find mode

Go to field C

Wait for user to enter date

Set field A to field C

Create a new find-request

Set field B to field C

Set field C to empty

Perform search

Ok, that’s the easy part. The problem you have is with wanting to use a report. You say using field C, but field C can have either a date from field A or from field B, not from both. Which field should be used first, or do you need both? If, for example, field A is more important than field B, i.e. your script should only check field B if field A is empty, then you simply need to use a case statement in field C, saying that C should be set to B only if A is empty. In other words, we need more information here. If the results of fields A and B need to be in separate reports, then perform one script in the main file, and then the next in the related file.

Or….. Use a third file: Find all the records that meet your criteria in file1, import them into file3, then do the same for file2. Then you have all the found records in one file. You see my point? The possibilities are endless. Give us more information.

Rigsby

Link to comment
Share on other sites

This topic is 7319 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.