Hi All

I search three db from a fourth db for inactive welders. I would like a message to pop-up when the search reveal that there are no inactive welders.

I have made relationships for the three db to the fourth db and have tried using the status(currentrecordfound) function to have message pop-up.

In the fourth db I have a define a unstored calculation field as such:

w_total = O_status + W_status + OP_status

0_status has 15 records, W_status has 20 records and OP_status has 22 records

This should give w_total a total of 57 records. But this displays 0 until a new record is added to one of the three db then it displays only the number in the recently used db.

When the script is run the message appears "No welders were found" regradless if a welder is found.

The script is as such:

Enter find mode

insert calculated results (for the three db)

Perform find

If w_total=0

Show message "No welder's record were found"

endif

But the w_total will not change from the number of records in the db until after the script is ran and then it will reset itself to 0. i hope i have explain this so someone can understand it.

Is there another way of doing this or ma I missing something.

Thanks

Lionel

oilman said:

I have made relationships for the three db to the fourth db and have tried using the status(currentrecordfound) function to have message pop-up.

Why don't you use your relationship for that purpose.

Count(::Rleationship:O_status) + Count(:Rleationship:W_status) + Count(:Rleationship:OP_status)

Hi Ugo

I have tried something similar to that and maybe i need to use count in front of the relationship.

This is what i tried

w_total = Relationship:O_status + Relationship:W_Status + Relationship:OP_status

thanks

Lionel

Without the Count you'll only be referencing the data from the first related record in each file, depending upon the relationship's sort. So you'll definitely want to use it.

thanks Queue