Skip to main content
chan2111
chan2111
New Participant
October 31, 2019

1:M link in ACS FK (relationship)

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

    chan2111
    chan2111Author
    New Participant
    November 20, 2019

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

    prasannakumarmarru
    prasannakumarmarru
    New Participant
    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
      New Participant
      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
      New Participant
      November 1, 2019

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

        Terms & ConditionsAccessibility statement

        Loading footer...