Table view
R

Hello, its possible to add fiel view table of a table is not linked?

Thanks

Ninox Profile

Yes with select statement.

 

Nick

Ninox Profile

Exactly as Nick said..   Here is a bit more... That is the purpose of the "View" layout element.   You drop that onto you form .. and then add a forumla for the select.     If you want to limit that is in the view.. You can manually add filters by clicking on the columns..   Of.. if there is a data element on your current form that may be used .. you can reference that field.

Here are a few snapshots for you. 

view

The formula.. references the "Filter Constraint" field.. 

formula

Entering a value into the "Filter Constraint" field .. and moving off that field will automatically manipulate the "view".. I use this approach a lot rather than "table view" (aka table grid).. as those appear to have to be manually refreshed. 

Filter Constraint

Ninox Profile

shoot.. my typing is aweful this mornig.. Sorry for the type-os above.. :( 

Ninox Profile

...or if you find Mconneen's answer a little science fiction :)

here is something simpler...

 

let myCode := Item.Code;
let myCust := Customer;
select 'Invoice Items' where myCust = Customer and myCode = Item.Code

 

Nick

R

Hi Guis,

Thanks for your share informations.

Have a nice days.

Reply