I have a field named [Account No] and in the properties of this field under the tab "data" I have the following a query built:
SELECT [CIF Accounts].[Account No], [CIF Accounts].[Short Name], [CIF Accounts].[Relationship Name] FROM [CIF Accounts];
so when an account number is entered it will populate automatcly two other fields [Short Name] & [Relationship Name]. My issue is that prior to building this SQL I had already data in the database and when I bring up the record the fields that need to be populated automatically are empty. Only way to populate that I know of is by retyping the account again and when I tab out of the field it does its thing and populates the other two fields automatically. Is there a easier way to make all records that are blank to re-index or something to refresh the data in the fields.
SELECT [CIF Accounts].[Account No], [CIF Accounts].[Short Name], [CIF Accounts].[Relationship Name] FROM [CIF Accounts];
so when an account number is entered it will populate automatcly two other fields [Short Name] & [Relationship Name]. My issue is that prior to building this SQL I had already data in the database and when I bring up the record the fields that need to be populated automatically are empty. Only way to populate that I know of is by retyping the account again and when I tab out of the field it does its thing and populates the other two fields automatically. Is there a easier way to make all records that are blank to re-index or something to refresh the data in the fields.