I've attached screen shots of the search macro and forms in use.
I am not certain how the macro is working.
It is supposed to be searching for the Episode ID and when selected should open the info for who it belongs to.
However, it is putting that id into the participant name and bringing over the data that matches that.
Not sure when, or how it ever got changed.
The background of the form it ends up presenting the info on is run off a query with the Client ad Episode tables, linked by ClientID
I'm trying to find out how to get it back to searching for the episode and placing the correct info into form that matches the client to that episode.
I am not certain how the macro is working.
It is supposed to be searching for the Episode ID and when selected should open the info for who it belongs to.
However, it is putting that id into the participant name and bringing over the data that matches that.
Not sure when, or how it ever got changed.
The background of the form it ends up presenting the info on is run off a query with the Client ad Episode tables, linked by ClientID
I'm trying to find out how to get it back to searching for the episode and placing the correct info into form that matches the client to that episode.