Customer and
Customer contact are two tables where Customer Id is
the link carried in customer contact table. In this
case, am I able to add both a new customer together
with the customer contact?
Design
Create custom
UDM with customer contact as a child node to the customer
node and bind the two nodes with customer Id. Both the
nodes should be Insert only.
Limitation
The child node cannot be a vector node
if it is a insert only node.
Steps to achieve
Click on the create custom UDM (name is as "addCustomer")
Give the display name as Add New Customer (bottom
part of the page)
Select the addCustomer node and click on the
add child toolbar
Give any name to the node (say Customer)
Select action type as Insert only
Select the table as "Customer" and
save
Select the Customer node and click on the add
child
Name it as CustomerContact (Note: No white spaces,
underscores allowed here)
Make it as Insert only
Select the Customer Contact table
Select
the correct binding between both the tables i.e. : CustomerContact.customer_Id
= addCustomer.Customer.Id
Save the UDM , preview the HTML and save the
HTML
Make the UI Changes and view in the browser
Test and add data
2.
Chassis and
PSU are two tables where the Chassis Id is a foreign
key carried in PSU table. It cannot be dynamic or it
cannot be a vector node for insert. In this example
we have assumed it has five siblings. In this case will
I be Able to add a new Chassis along with the 5 PSU
(power supply units) at one go?
Design
Create custom
UDM, with 5 PSU's as child nodes to the Chassis node.
Bind all the siblings to Chassis node. All the nodes
should be Insert only.
Limitation
Number
of child node records (i.e. No. of PSUs) to be added is
static.
Steps
to achieve
Click on the create custom UDM (name is as "addChassis").
Give the display name as Add New Chassis and PSU.
Select the addChassis node and click on the add
child toolbar.
Give any name to the node (say Chassis).
Select action type as Insert only.
Select the table as "Chassis" and save.
Select the Chassis node and click on the add child.
Name it as addPSU1 (Note: No white spaces, underscores
allowed here).
Make it as Insert only.
Select the PSU table.
Select the correct binding between both the tables i.e. : Chassis.id =PSU.Chassis_id.
Create a siblings to PSU1 called as PSU2, PSU3, PSU4,
PSU5.
Save the UDM , preview the HTML and save the HTML.
Click on the create custom UDM (name is as "addCustomer")