I have created a form that utilizes a lookup from the table's Field Rules. In this instance the fields (Last, First, FirmCode) are populated by a lookup on the FirmCode pulled from a table called Lwynames. This performs very well.
I have another table called Lwyfirms that include the FirmCode and Firm name, address, phone, and fax information for that particular firm, and have created fields for each of these fields.
Right now, the only way I can get the Firm Name, etc. to populate automatically is to have another lookup assigned to the Firm Name field, creating redundancy on the data entry side. Ideally, once the FirmCode field is populated it would automatically pull from the Lwyfirms table and populate the Firm name, address, phone and fax information.
To reiterate, the form contains:
1. Table LwyNames fields: AttyLast, AttyFirst, FirmCode
In the form there is a lookup on AttyLast that populates all three fields. (Attorney Name info)
2. Table LwyFirms Fields: FirmCode, FirmName, Address, Phone, Fax, Email
On the (same) form there is a lookup on FirmName that populates the Law Firm info.
I wish to use the FirmCode (populated when AttyLast is chosen) to populate all the Law Firm information as well as the Attorney Name information.
Picture attached. In it, the Attorney Name fields are populated and the pop up is the secondary lookup I have assigned to the FirmName field.
While this will work just fine, I'd like to streamline the process if possible. Any ideas would be greatly appreciated!
I have another table called Lwyfirms that include the FirmCode and Firm name, address, phone, and fax information for that particular firm, and have created fields for each of these fields.
Right now, the only way I can get the Firm Name, etc. to populate automatically is to have another lookup assigned to the Firm Name field, creating redundancy on the data entry side. Ideally, once the FirmCode field is populated it would automatically pull from the Lwyfirms table and populate the Firm name, address, phone and fax information.
To reiterate, the form contains:
1. Table LwyNames fields: AttyLast, AttyFirst, FirmCode
In the form there is a lookup on AttyLast that populates all three fields. (Attorney Name info)
2. Table LwyFirms Fields: FirmCode, FirmName, Address, Phone, Fax, Email
On the (same) form there is a lookup on FirmName that populates the Law Firm info.
I wish to use the FirmCode (populated when AttyLast is chosen) to populate all the Law Firm information as well as the Attorney Name information.
Picture attached. In it, the Attorney Name fields are populated and the pop up is the secondary lookup I have assigned to the FirmName field.
While this will work just fine, I'd like to streamline the process if possible. Any ideas would be greatly appreciated!
Comment