Dynamic field contents

[pesto]

Is there a way to make the value of one field change dynamically based on the values in other fields on the form?

Here's the general idea. I have two tables.

RecordTable
--------------
SiteID, etc.

SiteTable
-------------
SiteID, SiteBlurb

I want have a form, where you can change the SiteID value in RecordTable, and have the SiteBlurb change (i.e. the form pulls the information from SiteTable) dynamically once you have entered the new value.

 

[Fear Naught]

You won't change the site id as such. What you need is a search field - often better to use a combo box to do this. The combo box wizard will guide you through the process.