mibuso.com
Home› NAV/Navision Classic Client
Options

Using Flowfields in Access with linked tables to Navision 3.

marcelvandeventermarcelvandeventer Member Posts: 2
edited 2005-05-03 in NAV/Navision Classic Client
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.

Comments

  • Options
    PaddyMullaneyPaddyMullaney Member Posts: 59
    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.

    ](*,)
  • Options
    sblotsblot Member Posts: 21
    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.
Sign In or Register to comment.