One-many relationships

To illustrate how to set up One-many relationships with QuickAdmin, we'll use the example of an orders table.

We'll also introduce the simple search functionality here. This search box is set up to search for orders by either Order ID or Company.

Leave the box blank and click Search in order to return all orders:

Here's the code that defines this search:

<SimpleSearch>
    <QuickAdmin:Local LocalField=OrderID Runat=server />
    <QuickAdmin:One2Many Quotes=true LocalField=CustomerID ForeignTable=Customers ForeignKeyField=CustomerID ForeignDataField=CompanyName Runat=server   />
    <QuickAdmin:One2Many Quotes=true Title="Customer Company" LocalField=CustomerID ForeignTable=Customers ForeignKeyField=CustomerID ForeignDataField=CompanyName Runat=server />
</SimpleSearch>