How to reference fields in a related table without going through the picker
Hi, I have a table with employee information such as name, title, and employee number. I have a separate table in which to assign assets to said employee. The two tables have a relationship such t...
When I use the direct entry field, the only values that come up when it's saved are the "related employee from direct entry or record picker" and "employee number direct entry", both of which equal the number I entered. And this makes sense given the formula.
If I use the picker, the "related employee from direct entry or record picker" is equal to the value I 'picked', otherwise, "related employee from direct entry or record picker" is equal to the value I entered in the direct entry field.
Here are the two relationships I have set up between the assets (checked out) table and the employee information (card and employee numbers) table
Yes, there are duplicates. Once I get something up and working I can delete the duplicate information. Below I assigned an asset (a physical key) to Mr. E. First I used the picker to select him and the information populated. In the second row I assigned a different asset to the same person, this time using the direct entry but no information populated.
*note* all information is made up for test purposes
I think this means I need a relationship between the direct entry field and the information I'm trying to get it to populate (from the card and employee numbers table). But now I'm back where I started, trying to type in an employee (or ID card) number and getting the name and title to populate. >_<*
Sorry if this is too much information. I was thinking out loud, trying to process.
