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.
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?
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.