• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Applying Saved InfoPath Data > The Related Access Tables

The Related Access Tables

The data needs to be inserted into two Access tables that have a one-to-many relationship. The SalesPerson and OrderDate data points are fields in the tblOrders table. The tables, tblOrders and tblLineItems, are related with the OrderKey field. OrderKey is the key for tblOrders and is the foreign key in tblLineItems. See Figure 16.3.

Figure 16.3. Related Access tables to be filled with the XML data



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint