A flowfield make slow a table

DarkHorse

Hello, I have a new field on VatEntry table, this is a FlowField, but the problem is that it made the table very slowly on run it or run a vinculate report. I should like know how do it faster, may be putting keys?.
Thanks in advance.

kine

1) Version
2) Native or SQL DB
3) It is SUM or another function

DarkHorse

Yes, sorry. It's Attain 3.70, native, and the flowfield it's like this:

Method: Lookup
Table: VatEntry
Field: Client
Table Filter: Client=FIELD(Document No.)

(Client it's a field created by me)

Thanks in advance.

kine

May be I missed something, but you are filtering the table on Client field based on the "Document No." on the calling table and you are looking up the field Client? It means that each time you will have same value as in the "Document No." field on the calling table... or there is some mistype...

DarkHorse

That's right, I know it's a little stange, but I need to do it due to another process that the table do.
Thanks.

kine

DarkHorse wrote:

That's right, I know it's a little stange, but I need to do it due to another process that the table do.
Thanks.

I cannot think out any process which will need such a hack, but ok...

Check, that there is key on the table VatEntry beginning with field "Client". If not, try to add this key.

DarkHorse

Ok, thanks for reply; I'll try to put it as a key.
Thanks again.

David_Singleton

DarkHorse wrote:

Yes, sorry. It's Attain 3.70, native, and the flowfield it's like this:

Method: Lookup
Table: VatEntry
Field: Client
Table Filter: Client=FIELD(Document No.)

(Client it's a field created by me)

Thanks in advance.

If you know that client = document no then why do you need to look it up.

Are you sure you are doing this the right way?

DarkHorse

Yes, it's right, I know it's strange; the reason is that there is a process that compares these fields to do something with them, but is very long to explain. In any case thanks for your interest.
Thanks for your help.