insert into 1-1 tables

insert into 1-1 tables

sinyakov86sinyakov86 Posts: 1Questions: 1Answers: 0
edited June 2018 in Free community support

Hi all,

I need you help!

I have 2 tables, 1-1 relationship, for example:
table_1 (id, name, table_id_2)
table_2 (id, name)

In grid show all column from table_1, table_2 tables.

But how implement Insert into this tables? With edit no problem, hidden field table_id_2 help with it.

When try insert - get the error:
Field 'table_id_2' doesn't have a default value

If you need more details, please let me know.

Thanks in advance,
Alex

Answers

  • colincolin Posts: 15,240Questions: 1Answers: 2,599

    Hi @sinyakov86 ,

    We're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

    Cheers,

    Colin

This discussion has been closed.