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 -
The error message that you are seeing is the first issue to solve. As it indicates, you have an invalid relationship.
The "T" connectors are a key clue here.
Change Record to be a number field that auto-enters a serial number or a text field that auto-enters a UUID. (Or a number field that auto-enters a UUIDnumber.) Get ( RecordNumber ) returns a record's position in the current found set. It is not a unique ID.