Using Flowfields in Access with linked tables to Navision 3.

marcelvandeventer

Hi there

I have linked tables to a Navision 3.7 Database.
When designing the tables, all the flowfields' datatypes are TEXT in Access 97. This causes problems if you want to use these fields in caculations in Access within queries, reports etc. How can I get around this problem?
Do I need to use a "convert" function?

Thanks.
M.

PaddyMullaney

You are out of luck. You will have to re-buld the fields using the original logic. Th easiest way is to look at teh Select statement on the properties for the field in Nav table designer, and re-use this.

](*,)

sblot

neither the flowfield and the relation can be use directly by the NODBC driver.

For the flowfield you need to use the function Pred setflowfilter in the clause where.

For the relation (beetween tables) you need to setup the driver.

regards.