laker_42 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Posted March 9, 2005 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 Posted March 9, 2005 Posted March 9, 2005 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 Posted March 9, 2005 Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 9, 2005 Author Posted March 9, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Posted March 10, 2005 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 Posted March 10, 2005 Author Posted March 10, 2005 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 Posted March 10, 2005 Author Posted March 10, 2005 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 Posted March 10, 2005 Author Posted March 10, 2005 Does FMP recognize this as a bug? I think I will give them a call to see what they have to say. Thanks, John
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now