I can’t thank the community enough for answering my questions! My next question is how to add a record from interface designer.
I have 2 tables; Names and Attendance. Names has all metadata associated with an individual person. Attendance table is going to be used for tracking if a record/person in Names table has logged in. Every person in Names table has a unique_ID.
When I create a new interface, I can add 2 elements; Name and Date. Date works just fine but when I Add Record to Name it shows the unique_ID, not the person’s Name which is metadata in the Names table. In other words, I want to select a name from the Names table and add it to the Attendance table with the data from the interface. Any idea what I’m doing wrong?
Is it compulsory to have the IDs on the first field in the Names table?
If it is not, using people’s names on the first field solves the problem. This can cause problems for same names. If it cause problems, using a formula field as the first field which combines names and the ids can help you. So, creating Name and Id fields separately, then using the formula <Name & “-” & Id> in the first field can be a solution.