Hello,
I made a form which is linked to a table (say table1); this works great: I can, add, edit and delete records from the table linked to this form.
From what I understood so far while experimenting with nuBuilder, is that the table is "statically" linked to the form (SELECT * FROM table1).
But I wanted to be able to edit another table, or actually multiple tables, from the same form; without having to re-create the form.
So I cloned table1 outside nuBuilder (phpmyadmin), and created table2, table3, etc.
Every time, I want to use a different table, I manually go to the form and edit the SQL statement:
SELECT * FROM table2 , or SELECT * FROM table3 , and so on.
I searched the forums, hoping that I can find a way to call the form (thru "Open Form Button", or another object) and pass the "table name" as a variable, but couldn't find a clear answer, or possibly didn't use the correct search terms.
What I would really like to do from within nuBuilder is to be able to:
1- Call a form from an object (button), while passing the "table name" I want to use, as a variable to this form
2- Clone the table linked to the form, either structure only (empty, i.e. start from scratch), or structure + data (start from an already filled table); this is not very important at the moment as it is easy to do from phpmyadmin, but it could be a nice feature.
If this is something that can currently be done, could you please point me to the right direction/post or documentation.
Thank you kindly.
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Choose the Form Table on demand; one form-->multiple tables
-
- Posts: 1
- Joined: Fri Oct 28, 2016 2:10 am
Re: Choose the Form Table on demand; one form-->multiple tab
banayotti ,
Sorry but nuBuilder uses only 1 table on a form unless you add subforms.
Steven
Sorry but nuBuilder uses only 1 table on a form unless you add subforms.
Steven