Linking fields through alias table

[Ekhart]

So this is probably a simple fix that I am just not seeing


I have a form with 2 fields, Clinic and ConsultName. The information pulled from multiple sources uses different names which is why we have both.
There is a table, tblConsultAlias, that links these. For example the table shows that Allergy = 636A8/IC/Allergy. So depending on where this is updated on the form I'd like it to update the other field to match based on this table.
Example you update the field Clinic to say Allergy it auto puts 636A8/IC/Allergy in the ConsultName field and vice versa.

All data is stored on the Scheduler_Sheet table, however previously the ConsultName was not tracked, however some reports we pull data from have started to use this so now we need it which is why we created the table to link the 2 together.

[orange]

Show us your tables and relationships as a jpg.

Readers have no idea what this is??? Scheduler_Sheet table

Provide an overview of the business in clear, simple English - telling us about the subject matter involved and how these subjects relate to one another.
Readers need some context to understand your environment and issue and to offer focused advice.

[ssanfu]

I would use a UDF in the after update event of a text box to update the other control.


Different user name and a little different terms, but possibly cross-posted at http://www.utteraccess.com/forum/ind...wtopic=2047673.