Tutorial available?

Fundi

New member
Hi all
I am new to DADABIK and find it very interesting.

To learn it a bit more I like to find some tutorials if such exist.
Any help is appreciated. Especially trying to get a main record form one table to relate to a list of records in a second table.
I.E. Customer to Invoices (Display customer info on top and a table with invoices below. )

Thanks in advance.
Fundi
 

eugenio

Administrator
Staff member
Hi,
for the moment you can use the documentation and the forum.
I hope to have enough time to create and publish a video tutorial on youtube soon.
 

Fundi

New member
Hi eugenio Thanks for your answer.

I have gone reasonably far with trying out and fiddling. The one think though that I don't seem to get right is the following:
If I get this right I will write a nice tutorial.

I have a customer table and a Job table.

I like to select a customer in a drop down box and then below all the Jobs of that customer should appear in a table. This would be something like a Master/Detail scenario. But I find no documentation on the Master/Detail issue except what is on the Question mark button in the interface Configurator and that is just too little for me to make it work.

Perhaps I miss understand the whole thing.

Here are my Tables:

Customer_TBL
ID
Customer
Address
Phone
Cell
Email

Job_TBL
ID
Job
Customer_ID (from Curtomer Table)
Description

How does one tell Dadabik to make a Master/Detail view?

Thanks for any Help.
 

dellaera

New member
Hi Fundi.
You must read http://www.dadabik.org/index.php?function=show_documentation#configuration.
When you are in the Interface configurator, you can set values for your master/detail view.
In your situation, you must manage the Interface configurator of "Customer_TBL" and you can set more than one detail table. Imagine you have another table, i.e [pre]
Children_TBL
ID
ChildName
Children_Customer_ID (from Customer Table)
[/pre]
you may set these values
  • if you want to set only one detail table
    [pre]
    • Linked items table names = Job_TBL
    • Items table foreign key field names = Customer_ID
    [/pre]
  • if you want to set two detail tables
    [pre]
    • Linked items table names = Job_TBL~Children_TBL
    • Items table foreign key field names = Customer_ID~Children_Customer_ID
    [/pre]
:) Enjoy.
Modesto
 
Top