Using the help section Lookup Table, I used the Auto Fill information to try and configure the following below, but for some reason when I generate and publish the project the auto fill function is not populating fields that are configured.
In one of my tables that is part of a Master Detail setup, I have configured a field called ProductID to select a product using a drop-down. Also, I have configured Auto Fill on this field to fill in the Vendor and Price of the selected product in the details table InvoiceItems.
InvoiceItems (table)
InvItemsID (primarykey)
InvID
QTY
ProductID
Description
Price
Vendor
Cost (custom field: QTY * Price)