Flowfields - Sql Queries ?

elephant_man

i am very new at navision. I am writing web programs also. so i used to make database tables like this:

Table1 : Films (filmid,runtime,year...)
Table2 : Genre (genreid,Genre)
Table3 : FilmGenre(fid,gid)

but in navision i think i must use flowfield or something near to that to show them in forms reports vs.

How can i use them and where can i put those flowfields?

How can i change my mind to navision?

Is there a field or anything else to run joined sql queries?

garak

hello, elephant.
a good starting point to learn the programmers language is to read the manual "w1w1adg.pdf" (search for it).
A flowfield is a field that doesn't store any values. The value is calculated at runtime by a formula (like sum, max, avg, exist, etc).

So on your example you need, for example in table films, only a flowfield if you need to know how many genres a film has (calcformula = Sum on table Filmgenre where Fid = FilmID). So the rest of you question i doesn't understand. Do you have problems to create the tables and the reports / forms or do you have problems to design the whole functionality of your application?

Regards

elephant_man

thanks but someway i need to show film's genre names in my card form. Can't i write query in source expression of that form tool? also what's my advantage for using sum flowfield and know how many genre on that film. i only want to show the names in forms and reports...

DaveT

Hi,

Think the problem is in the table design - why not add gid to the film table. Then add a count flowfield to the Genre table where genreid = gid.

The form will be based on the genre table and if you click on the count filed it will show all the film ( make sure you have a list form accosiated with the film table )

Hope this helps