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?

[Ankur Bawiskar]

@AllanPG 

any flow configured on that table?

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

[AllanPG]

Yes, there are no flows also. The last  thing i did was create the form and  for both tables and  setup the reference field.  Thats why I was  stumped  when I noticed the blank record in the ASP_Master when I create a new record on the ASP_Release table.

[Ankur Bawiskar]

@AllanPG 

by any chance when you are trying to set the reference field are you clicking on New button within that lookup?

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

[AllanPG]

I did not notice any New button for setting the reference field.

I did try yo  disable this reference field and entered a new record for the ASP_release. Still there was a new record also created in the ASP_master table with blank fields except for the number.  I still have not found the culprit why or how this is happening. 

[Ankur Bawiskar]

@AllanPG 

not sure but we can't help much as we don't have access to your instance.