ContributionsMost RecentMost LikesSolutionsRe: can i import field that have been designated as lookup field/or formulas? Key fields?my apologies.I was handed this off mid-stream.Contact Name is the field and is a numeric field (reference); however, under its properties in the reference field options .. is has a proxy field of 'individual policyholder'.Individual Policyholder it a 'text lookup' (reference proxy).Under Individual Policyholder's properties, it has a reference field (in this table) of 'Policies: Contact Name' and a value field (in the foreign table) of 'Contacts: Full Name'.Re: can i import field that have been designated as lookup field/or formulas? Key fields?the master table is contacts with a key field 'record ID#'Re: can i import field that have been designated as lookup field/or formulas? Key fields?Yes, the relationship is one contact to many policies.The reference field is 'contact name' and is a numeric reference.Re: can i import field that have been designated as lookup field/or formulas? Key fields?did as advised; however, there was no field 'related contact' to choose from?also get error - Some record IDs specified were not found in the table.I know the record ID's exist, but on the contacts table and not on the policies table.any ideas?can i import field that have been designated as lookup field/or formulas? Key fields? I have a 'contacts' table and a 'policies' table. they have a relationship through key field 'record id#'. i have an excel spreadsheet that has all the headers needed for the fields in my table; however, I can't get it to link to the contact in the contact table. How can I import my policies that are associated with a particular contact so that the policy is assigned to that contact? When I create a policy from within the table I select product name and individual policy holder from a look-up to other tables; however, I want to import those fields from the spreadsheet in these cases.