Hi all,

here is my issue.
I have 2 table

T1 with fields T1.ID (the primary key), T1.F1, T1.F2, T1.F3, T1.FK1 (linked to T1.ID)
T2 with fields T2.ID (the primary key), T2.F1, T2.F2, T2.F3

Basically T1 may inlcude more information on T2 and, in case, T2 will "extend" T1 by inserting the foreign key FK1.

Now I'd like to be able to create a form for a T1 single item which displays:

T1.F1
T1.F2
T1.F3
T2.F1
T2.F2
T2.F3

In case F1 or F2 or F3 is fufilled, a new entry on T2 should be created and linked to T1.

Now I understand that I may have to an insert on T2 and get the key in order to be able to do the insert on T1.
My question is, how can I facilitate the work using J-Cook?

Also, when I try to display T2.F1 or T2.F2 or T2.F3 on the form (e.g. integers) I get combos or list or radio like when I select a FK from other tables. What I was expecting was to be able to input integers on those fields with a numeric input box.

Thanks for any help I may get.

Hi There,

please take a look at the following to see if any f them answer your question:
www.j-cook.pro/forum/9-coding-inside-you...ating-data-upon-save
www.j-cook.pro/forum/14-news-a-chillout/...ltiple-items-at-once

G

Many thanks for your help. I never used AIAX but it could be a good opportunity to learn something about it.
I'll give it a try and I will post my results.

Cheers