dynamic lookup

[raingirl]

I need to use a lookup field to make a relationship that uses an indexable field. Is there a way to evaluate or dynamically lookup this field without forcing the user to relookup records. Upon data entry in the current table, upon entry of other fields from the other table, etc. This is a very frustrating aspect of the multiple tables now - getting information to each area without a lot of manual effort.