Table Reference Confusion
I created a table reference between employees and invoices. I get the error in the data modeler. But when I add the field to the employee first name (from employee table) to the invoices table, I don't actually see the employee name until I click on the field and Ninox takes me to a totally different screen.
How do I see the related values on the same form without this extra step?
Thanks,
7 replies
-
In your reference field did you set the Show as to show only the fields you want to see?
You have think of the Show as section as a formula field so if you want to show multiple fields you have build it like:
LastName + ", " + FirstName
Or any combination of fields and added text.
-
Fred Here's how I set it up. Do you see what's off? Thanks
-
Mike It seems like I have to click on each employee item in the invoice table before I see the first name (instead of them all showing automatically).
-
When you select Embedded then the Show As is not used as it now shows the default form from the employee table. If you change it to Popup then Show As works.
I'm not sure what you mean by:
Mike said:
I have to click on each employee item in the invoice table before I see the first name
-
-
I had popup, the default, initially. But, what happens is that on the invoice table where the employee first name (linked) field is, that field is blank until I click on it, get taken to another form and click on the employee name there. Then, it's linked. If this is still confusing, I can create a quick sample DB and post it. Let me know. Thanks.
-
That is how a popup works. At first there is no link, then you click on the field and it shows you all the records from the other table, so you can create the link. By the way, Ninox doesn't link by fields but from record to record. That is why you create a reference field to a table not a specific field. You are choosing to only show the first name field but that is not what Ninox uses to link the records.
Looking at your picture again, I don't understand the constraint part. If you are in a record in invoice and need to link it to an employee why would you want to limit your choices. Plus since you have picked an employee I don't see how you can limit your choices? What happens when you remove the constraint?
Content aside
- 2 yrs agoLast active
- 7Replies
- 74Views
-
2
Following