when I create a record in custom table a blank record is also created in another custom table?

[AllanPG]

Hi there, 

I have created 2 custom tables

Table1: ASP_Master
Fields: asp_number (sample number ASP000001)
            asp_name
            asp_description

Table2: ASP_Release
Fields:  ref_number (referencing the ASP_Number)
             release_number (sample number REL000001)
             release_description

I created a custom form for both tables. I did not enable any business rules or run any scripts.   When I inputted data using the custom form of the ASP_Release,  the new record is created for that table.  But I noticed there is also  a new record created in the ASP_Master where the asp_number generated is the same format/pattern with release_number and all the other fields were blank.  As for the ASP_Release table the new record was generated with all fields having the entered data.  

Could anyone  help me understand,  What could be the reason for this and how can I fix it?

[maheshkhatal]

@AllanPG  Since you have mentioned no BR or anything pre-configured stuff, tough to guess. What I think is that may be the issue you're experiencing is likely due to the Reference Field configuration between the ASP_Release table and the ASP_Master table. Specifically, the ref_number field in the ASP_Release table is likely configured as a Reference Qualifier or Reference Field that automatically creates a new record in the ASP_Master table if the referenced record does not exist.

If my response helped you gain insight mark my response as helpful.

Thank you,

Mahesh.

[AllanPG]

@maheshkhatal ,  Is there a way to confirm your assumption?  Because when i configured the ref_number field  i just selected the field type as Reference and then indicated the ASP_Master table. I did saw the options for "Use reference qualifier", but i did not modify it. Its currently its set as Simple.

[Ankur Bawiskar]

@AllanPG 

there could be some business rule or flow created on ASP Release table since these are custom tables

Did you check that?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AllanPG]

@Ankur Bawiskar , yes I have checked the System Definition - Business Rules, and there are no items found for both custom tables.