braga
New Member
I have three tables in a database of Mysql that I want to visualize and to modify via web by Fabrik.
First Table: IDFiscale - Name - Address - Telephone etc...
Second Table: IdContract - IDFiscale - number - Date Effect - Date proceeds - Total - IdPayment
Third Table: IdPayment - Kind of Payment
I have inserted in the table Contract the inners joins between IDFiscale-IDFiscale and IdPayment-IDPayment
I have noticed that Fabrik has generated new groups like "Address - [ joined to Contract]" and "Kind of Payment - [joined to Contract]... and the same thing in the Elements
Now I want to visualize in the web page only part of the fields from the tables for ex. the Name -Date effect- Date Proceeds - n.contract - Total - Kind of payment.
I want also search by name and number of contract and write in some fields like total and change Kind of payment.... and so to bring all to the mainmenu.
How do I construct the form necessary to this visualization? I have to Use the "elements - joined" or the others? Can an element be put in more groups, is there some example in order to help in this case? If i change a elements in a group I modify the other view that I have made? Thanks a lot I'm a little confused
First Table: IDFiscale - Name - Address - Telephone etc...
Second Table: IdContract - IDFiscale - number - Date Effect - Date proceeds - Total - IdPayment
Third Table: IdPayment - Kind of Payment
I have inserted in the table Contract the inners joins between IDFiscale-IDFiscale and IdPayment-IDPayment
I have noticed that Fabrik has generated new groups like "Address - [ joined to Contract]" and "Kind of Payment - [joined to Contract]... and the same thing in the Elements
Now I want to visualize in the web page only part of the fields from the tables for ex. the Name -Date effect- Date Proceeds - n.contract - Total - Kind of payment.
I want also search by name and number of contract and write in some fields like total and change Kind of payment.... and so to bring all to the mainmenu.
How do I construct the form necessary to this visualization? I have to Use the "elements - joined" or the others? Can an element be put in more groups, is there some example in order to help in this case? If i change a elements in a group I modify the other view that I have made? Thanks a lot I'm a little confused