AnsweredAssumed Answered

Help with Lookup function

Question asked by reverend on Nov 30, 2018
Latest reply on Nov 30, 2018 by philmodjunk

Hello all -

 

This is just a small example of a problem I am having on a larger scale although the results are the same. I just cannot seem to get the lookup function to work in either case. I must be overlooking something obvious.

 

I Have the following setup:

This is the data entry screen

This is the data request display. The field to the far left is the record request field. Just a number entry box you are supposed to be able to type into. The three fields to the right are the requested data fields.

This is the data request error dialog I get when clicking into any field.

This is my enter data layout

This is my request data layout

Here are my data fields defined, request fields defined, tables and relationships. Note that in the Tables view the records between the two tables differ. Actually the request table has zero (0) records. I suspect that is where my problem is with all the "?" marks in the request data screen.

 

 

 

 

Any thoughts.

 

Thank you in advance.

 

- rev -

Outcomes