Hello,
I am trying to use a lookup under field rules to populate the several fields in a parts table based on the lookup. For example if a use selects item 001, it will fill in the description field and the price field based on the information in the lookup table. I have set this up using field rules with a dbf table that was imported and it works fine. The user can either type in a few characters (closest match parameter is set in the field rule) or select the item number from the drop-down, and the data will fill the field with the drop down as well as the price and description field. When I use the exact same method with an active-link table attached to a sql server copy of the table, the user must open the drop down and select the item for the other fields to populate. If the user just times a few characters and hits tab, the closest match works fine, but the other fields are not filled. If he clicks on the drop-down and then clicks on that time, the other fields do fill when you press tab. Why would the behavior be the different for an active link table v/s a dbf. I am having a similar problem with record list combo boxes and active link tables under a different post. I've been able to duplicate both problems with the Alpha Sports if I add an active link table.
I am trying to use a lookup under field rules to populate the several fields in a parts table based on the lookup. For example if a use selects item 001, it will fill in the description field and the price field based on the information in the lookup table. I have set this up using field rules with a dbf table that was imported and it works fine. The user can either type in a few characters (closest match parameter is set in the field rule) or select the item number from the drop-down, and the data will fill the field with the drop down as well as the price and description field. When I use the exact same method with an active-link table attached to a sql server copy of the table, the user must open the drop down and select the item for the other fields to populate. If the user just times a few characters and hits tab, the closest match works fine, but the other fields are not filled. If he clicks on the drop-down and then clicks on that time, the other fields do fill when you press tab. Why would the behavior be the different for an active link table v/s a dbf. I am having a similar problem with record list combo boxes and active link tables under a different post. I've been able to duplicate both problems with the Alpha Sports if I add an active link table.