1:M link in ACS FK (relationship) | Community
Skip to main content
chan2111
chan2111
Level 4
October 31, 2019

1:M link in ACS FK (relationship)

  • October 31, 2019
  • 2 replies
  • 17615 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.

    2 replies

    prasannakumarmarru
    prasannakumarmarru
    Level 4
    October 31, 2019

    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!

      chan2111
      chan2111Author
      Level 4
      November 1, 2019

      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
      prasannakumarmarru
      Level 4
      November 1, 2019

      May I know what datatype is that? I don't remember the error, will try again and let you know.

        chan2111
        chan2111Author
        Level 4
        November 20, 2019

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

        Terms & ConditionsAccessibility statement

        Loading footer...