I have a list of shippers and consignees and I need the user to select 1 shipper and 1 consignee and save this value into the cargo table. There is aprox 3000 different address to pick from for each field (shipper and consignee). How do I do a multi column look up. I read someones post that mentioned making a formula field that adds customer, city and state. I did this and it works but I can not get this field (calculated) to be used as an autocomplete in the dataform. Basically the forms do not allow you to bring over calculated fields. Work around?