Open a table as a popup

as far as I know there isn't a popupTable command

you could use openTable to go directly to the table

openTable("customers", "all")

this opens the tabel called custoemrs on the all view

but this takes you away from the other table

Otherwise you could embed a table view into your form and have it on another tab or even hide it

I'm busy with work at the moment but when i get home I will show you a screen dump of how it have a vew that does this

John

if you wanted to to see a specifc record in the othet table you coukd use popupRecord() command 

Anyway

So when I'm in my jobs table I want to see all the quotes related to that customer as well as the last job done for them

so I use the popup record for the last job

and also have a table view that is limited to just that clients quotes (but you just show the whole table for your use)

So on my form I have a yes /no field called show quotes

then I added the table view

and set it to only show when the show quotes is true.

this has the effect of popping up

see screen shots

normal job screen!

 

 

screen shot when show quote = yes

 

view code

Pressing the yes button (flag) makes the fields and the table view become visiable and the rest of the job is shuffled down the page out of site

(I also use a large space attribute to make the rest of the page tidy). Pressing the show quote flag again turns off the visabilty and the job returns as per the first screan shot. 

As stated, this shows only the quotes that are related to that customer but it does not have to be - You could easily show all the quotes (or whever table you want to show)

I use the openRecord to show a directly linked quote for that job too and I use lots of variation of this..

ie when in jobs - show me all the jobs for today (without leaving the current job) etc

Hope above helps but as ever there will be other ways to do what you want.

Mel

Have you thought of using a view?  Select it from the layout items and use a select to use it.  When you click on a record this pops up.  You can also use an embedded field.  Andy from Nioxus explained this in one of his webinars and it works well. 

Hi John

Just remember the openRecord will only open 1 record wher as the table view as sateated by me and john will open all or a filtered list of records

It's easy to add a button to add a new record.  Make a button and make the code like this 

let c:= create "Table Name"

you can use c.fieldname to add any default informaton.  You can have numbers codes 

closeRecord()

popupRecord(c) 

 

that will add a new record to the table and it wiill show up on the view.    

then don't use the closerecord button().  On a view you can size the form that pops up to see all of the other records.  You will have to go back to the original table of the view and size it there then it will work on your form.!