How to use relational tables in j-cook? is it possible?

Hi and welcome!

Relating tables is pretty straight-forward thanks to cook!

Lets say you have 2 tables - families and family_members each with an id (auto created in cook) and a name field + in the family_members table, add a foreign key field type called family. Then, from your tables list on the left-hand side, drag the families table into the dashed div and click the save button. That's it! Simple, eh?

Now all you have to do is create a layout to enter and view data for both tables. When you do this and you drag your fields to the layout, simply click the + sign on the foreign key field (family) and drag one of the related fields from that table to your layout. This is what you'll see in your layout - either in the combo dropdown on your form or in a grid/fly.

Hope it helps,

Gez

what you describe is a 1 to 1 relationship right?

because I need a 1 - n relationship

Hi,

No this is a 1 - many relationship. You could add multiple family members to a family in this example.

Gez

so, if its 1 - n its not working =(

I added 2 families

then in family members added 2 names with the same family,

and this create 2 regs with the family but both with and unique Id....

Yes, but there is only one family id there - your foreign key. 1 family->many members = 1-n

I should be able to open a family en see the family members

You need to create a layout for that - 1 where you filter by family and show related members. What you are currently looking at is family members from all families.

You'd need separate query - prepareQuery() function in your model to get say family 1 and all of it's members.

Gez

Ok, but that cant be done here in jcook right?

can you tell me the use of "default" in table it s like "primary key" ?

there's a few things you can do:

1 - add a filter to the table based on your family
2 - group by family (find this in your grid properties of the layout
3 - as I said before, add a where clause in a new 'case' so you can switch to filter by family.id (after download)

Hope it helps!

Gez

thanks I'll try, when Paid the account, in order to download (when I'll be satisficed that cook fill my needs)

I got a problem with the relation

I added the relation to the view... and added the field from the FK table, the field is an BOOLEAN
when I added to the layout it shows a dropdown empty.

What happens there?

I can only add just 1 record from the fk table??????

Yes of course.

1:N is linking only one foreing element.

If you want to connect multiple, you need N:M.

N:M is possible manually in Cook. Then to show them you must code a little bit.

Admin, thanks, I just paid the 6 months! (not with this account) I'm very exited!