Level 4

1:M link in ACS FK (relationship)

Forum|Forum|6 years ago
October 31, 2019
2 replies
17621 views

There are 2 tables A,B.There is FK in the many side of the table A referring to the PK of the table B. I have a requirement that 1 record in the source table B will have many records in the target table A and a record in table A may have the FK value as null/empty.

The question here is if there is an FK whose value is null/empty in the Table A is there a way we can make the field nullable in Table A in ACS.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

prasannakumarmarru

Level 4

Chan,

You cannot use nullable Foreign keys in ACS, I have tested it just now and It is creating NOT NULL fields every time. I think you can use 0 as default value when it is created instead of null. Thanks!

chan2111Author

Level 4

I have tested it too ,but is there anyway to make it empty or nullable was the question. So when you try to insert null values in FK field may i know what is the error you were facing. The record will be inserted but when i try to open that record from recipient schema it says resource unavailable/the links are not correct/contact administrator. Were you getting the same error?

prasannakumarmarru

Level 4

String

Hi Chan,

I created tables test and test2, joining with test(fkey is a foreign key) referencing test2(cid).

When pulling test2 data with collection of test data, I am not able to add the element from test table in additional data section and seeing this error-

But I am able to pull test data as main resource-

But when adding the additional data(test2 - cid), it will not show null records as they are not referencing any records from Test2 table, as fkey is null.

Thanks!

chan2111Author

Level 4

Please check if you are able to open the record in the client data section.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded