Problem after import

[mrules45]

I imported my whole database from MySQL and everything works, except for the new clients I've added to the database. The new clients seem to have issues with the fields that deal with calculation. Any ideas?

[Vaughan]

You might have to explain what the "issues" are in a little more detail.

At a guess I'd suggest looking at the calculation fields (and seeing whether they really are calculations); and if they are Ok, whether they need to be unstored.

[mrules45]

ok ill attempt to explain.... i have two problems with new clients. first off thought i have to tables, one called Client Data and one called Payment Data, they are related through the Client ID(a unique number). So the first problem is getting the clients full name to display in the payment data layout, their is a field in client data called "Full Name" its a calculation:

First Name & " " & Last Name

now this displays fine in the client data layout but when i make a call to it in the payment data layout it wont display for new clients(added after the import)

now the second problem is that with the new clients i can not get their total payments to sum properly. in the client data table there is a calculation field called "Overall Payments" which is:

Sum ( Payment Data::Total Payment )

now when this field is called on my reports it shows up for the old clients but not the new ones. i know that this was alot, any ideas?

Edited March 16, 2009 by Guest

[LaRetta]

You mention that it works in the 'old data' ... have you checked the new clients and do they also have a ClientID in both the Client table and the Payments table? If they are additional newly imported data, how are you relating the new 'payment' data to the new 'client' data so that payments are using the correct Client key? Are you remembering also to apply 'perform auto-enter' so your keys even populate or do you import the keys with the data already related in the old set (in which case you SHOULDN'T use auto-enter in the new tables).

We need more information and I suspect these items above because importing a client's payments with the client won't work unless you someone maintain (or re-establish) the new Client primary keys through the payment data.

Edited March 16, 2009 by Guest

[mrules45]

everything seems in order its just not displaying the full names. after looking further i found that its not just the newly entered data, its seems to be random. ive included a picture of the problem in table view:

the second column is being pulled from the other table client data(the table in the picture is payment data)

so this all leads me to believe that there is something wrong with the storage setting for these fields. any other advice?

thanks for all your help so far

Edited March 17, 2009 by Guest

[mrules45]

i fixed the whole problem. it was happening because the client id was related to client data through another table that contained incomplete records.

thanks for all the help

[LaRetta]

Okay, then it is not just 'new clients' vs 'old clients'?

You indicated two problems: FullName not showing and (from Clients) payments not summing. If there was an issue with the relationship (and all fields have the proper ClientID) then you could indeed have an index issue.

Use the new FM 10 feature and reindex all your indexed fields (I don't have vs. 10 at home to check but I think it's on File > Recover. Back up first.