My find in a calculated field won't work, help!!!

[laker_42]

I am having a strange problem. I have an Order Total field that is a total of product line items and sales tax. It is calculating correctly. The strange happens when I try to do a find for a total > 25. It comes back and says that it can't find any that match the criteria. If I scroll through the records, there are many records that fit the criteria. Any ideas what would be causing this? It started doing this after I deleted all the records in my tables and reloaded the records from a fresh copy of our production system. Before the reload, it was working correctly. I have no clue what is going on. I would appreciate any info.

Thanks!

John

[laker_42]

I am having a strange problem. I have an Order Total field that is a total of product line items and sales tax. It is calculating correctly. The strange happens when I try to do a find for a total > 25. It comes back and says that it can't find any that match the criteria. If I scroll through the records, there are many records that fit the criteria. Any ideas what would be causing this? It started doing this after I deleted all the records in my tables and reloaded the records from a fresh copy of our production system. Before the reload, it was working correctly. I have no clue what is going on. I would appreciate any info.

Thanks!

John

[laker_42]

I am having a strange problem. I have an Order Total field that is a total of product line items and sales tax. It is calculating correctly. The strange happens when I try to do a find for a total > 25. It comes back and says that it can't find any that match the criteria. If I scroll through the records, there are many records that fit the criteria. Any ideas what would be causing this? It started doing this after I deleted all the records in my tables and reloaded the records from a fresh copy of our production system. Before the reload, it was working correctly. I have no clue what is going on. I would appreciate any info.

Thanks!

John

[laker_42]

Just an update as to what I have tried. I thought maybe something was corrupted so I ran the recover tool on the ProductSales & Lineitems tables. It didn't make a difference. This is actually happening with several of my calculation fields. I have an invoicesubtotal field that is simply Sum(ProductLIneitems::ItemTotal). It shows up correctly but I can't do a find on it either. I can do a find on the ItemTotal field in the LineItems table and it works correctly. My Sales table is related to the LineItems table by OrderNum. This is getting very frustrating. I don't understand why it stopped working all of a sudden.

An interesting thing, I just did a find and put in = into the SubTotal field. It returned all the records. So its like it doesn't recognize that there are values in the field?

John

[laker_42]

Just an update as to what I have tried. I thought maybe something was corrupted so I ran the recover tool on the ProductSales & Lineitems tables. It didn't make a difference. This is actually happening with several of my calculation fields. I have an invoicesubtotal field that is simply Sum(ProductLIneitems::ItemTotal). It shows up correctly but I can't do a find on it either. I can do a find on the ItemTotal field in the LineItems table and it works correctly. My Sales table is related to the LineItems table by OrderNum. This is getting very frustrating. I don't understand why it stopped working all of a sudden.

An interesting thing, I just did a find and put in = into the SubTotal field. It returned all the records. So its like it doesn't recognize that there are values in the field?

John

[laker_42]

Just an update as to what I have tried. I thought maybe something was corrupted so I ran the recover tool on the ProductSales & Lineitems tables. It didn't make a difference. This is actually happening with several of my calculation fields. I have an invoicesubtotal field that is simply Sum(ProductLIneitems::ItemTotal). It shows up correctly but I can't do a find on it either. I can do a find on the ItemTotal field in the LineItems table and it works correctly. My Sales table is related to the LineItems table by OrderNum. This is getting very frustrating. I don't understand why it stopped working all of a sudden.

An interesting thing, I just did a find and put in = into the SubTotal field. It returned all the records. So its like it doesn't recognize that there are values in the field?

John

[Brian C]

This problem is due to a bug in FMP. You cannot do a search via a relationship to a child table in a number field. The same problem exists in FMP v6. The only way around this is to do your searching in the child table directly, and bring other relevant fields from the parent into the child via a relationship in case you need search criteria from there.

[Brian C]

This problem is due to a bug in FMP. You cannot do a search via a relationship to a child table in a number field. The same problem exists in FMP v6. The only way around this is to do your searching in the child table directly, and bring other relevant fields from the parent into the child via a relationship in case you need search criteria from there.

[Brian C]

This problem is due to a bug in FMP. You cannot do a search via a relationship to a child table in a number field. The same problem exists in FMP v6. The only way around this is to do your searching in the child table directly, and bring other relevant fields from the parent into the child via a relationship in case you need search criteria from there.

[laker_42]

Here is the latest and it still is not any clearer for me. If I close the sales file on the server and open it without sharing. I can do the find and it behaves normally. If I open it back up on the server and access it via server, the finds will not perform.

Any ideas?::

John

[laker_42]

Here is the latest and it still is not any clearer for me. If I close the sales file on the server and open it without sharing. I can do the find and it behaves normally. If I open it back up on the server and access it via server, the finds will not perform.

Any ideas?:

John

[laker_42]

Here is the latest and it still is not any clearer for me. If I close the sales file on the server and open it without sharing. I can do the find and it behaves normally. If I open it back up on the server and access it via server, the finds will not perform.

Any ideas?:

John

[Brian C]

I stand clarified. Server bug. I have the same issues as well when running a solution from a FMP server. I have tested this in v6 and v7 in a server enviornment and have had the same result.

[Brian C]

I stand clarified. Server bug. I have the same issues as well when running a solution from a FMP server. I have tested this in v6 and v7 in a server enviornment and have had the same result.

[Brian C]

I stand clarified. Server bug. I have the same issues as well when running a solution from a FMP server. I have tested this in v6 and v7 in a server enviornment and have had the same result.

[Brian C]

If you need help with getting your search to work correctly, feel free to post details and we can work through it together.

[Brian C]

If you need help with getting your search to work correctly, feel free to post details and we can work through it together.

[Brian C]

If you need help with getting your search to work correctly, feel free to post details and we can work through it together.

[laker_42]

Does FMP recognize this as a bug? I think I will give them a call to see what they have to say.

Thanks,

John

[laker_42]

Does FMP recognize this as a bug? I think I will give them a call to see what they have to say.

Thanks,

John

[laker_42]

Does FMP recognize this as a bug? I think I will give them a call to see what they have to say.

Thanks,

John