Linking child custom table fields to the different Base tables.

[Abhilasha G T]

Hi Team,

I have created the (Child table) custom table not extending any base tables  and added multiple fields in that.

i want to link this child table fields to the different base tables, 

how to achieve this.

Regards,

Abhilasha G T

[Dr Atul G- LNG]

Hi @Abhilasha G T 

There are 2 points in above statement

- What is your exact use case, are you just doing practice / hands on, if yes , then good and if no, please elaborate more. 

- i want to link this child table fields to the different base tables, 

Atul: If this table is not extended from any other table, then how it be a child table? also, when you say different table means, do you want to see other tables data on form or related list?

If on form, then new tabel field mist refer to other tables link User / group.

[Abhilasha G T]

Hi ,

I have created the  custom table not extending any base tables  and added multiple fields in that.

i want to link this Custom table fields to the different base tables,  like circuits, router and firewall..etc

how to achieve this.

And also i want to know maximum how many fields we can create in the table.

Regards,

Abhilasha G T

[Vishal Savajia1]

1. Create Reference Fields:

   • Navigate to "System Definition" > "Tables" and open your child custom table.
   • Create reference fields that will establish relationships with the desired base tables. These reference fields should be of type "Reference" and should reference the appropriate base tables.
   • For example, if you want to link the child table to the Incident table and the Change Request table, you would create reference fields like "incident_ref" and "change_request_ref" on your child table.

2. Configure Reference Qualifiers:

   • Once reference fields are created, you can configure reference qualifiers to filter the available records based on specific criteria.
   • Open the form layout of your child table.
   • For each reference field, configure reference qualifiers to restrict the available choices to the desired records from the base tables.
   • Reference qualifiers use the "Advanced" filter condition builder where you can define conditions based on fields in the referenced table.
   • For example, if you want to link the child table to only active incidents, you would configure a reference qualifier on the "incident_ref" field to filter incidents where the "active" field is true.

3. Establish Relationships Using Business Rules or Scripting:

   • In some cases, you may need to establish relationships between records in the child table and records in the base tables programmatically.
   • You can use business rules or client scripts to set the value of the reference fields based on certain conditions or user actions.
   • For example, when a record is created in the child table, you can use a business rule to automatically populate the "incident_ref" field based on specific criteria.