Button to open related record in a related table
hi everyone
i have a lot of question but "pasito a pasito"
I have three tables (patient data, image, interview)
the last two are related to the first one so that each image report is related to a patient.
Now, to make it easier to complete, I want to have a button on the patient form to open the corresponding image record, the same with interview.
something like clicking the plus button on imagen rectangle, but I want to hide this to be easier
another question is... is it possible that when I open a table go directly to a form or a more friendly view for the rest of the users?
thanks in advance
4 replies
-
If 1 patient has only 1 image and 1 interview then you can, at least, put an image field in the patient table. Depending on how big the interview table is you can also put all the field into the patient table and put them in a new tab.
If you want three tables then do what I suggested in my first comment. You need to create the relationship from images and interview to Patient. Not the other way around, which is what the arrows are telling us.
-
Hi there -
Did you create the reference table field to Patient Data from Image and Interview? It looks like you created a reference field field in Patient to Image and Interview. I'm guessing you want a 1 to many relationship between patient and Image and Interview (1 patient has many images or interviews). Well even if you don't have multiple images or interviews per patient the thinking is the same. In Ninox you have to create the link from the many side. Instead of a single line field that you see now in Patient you should see a table view into Image or Interview so you can see the many records related.
Give that a try and see if that changes any following questions.
-
hi
thanks for response
I need 1:1, one patient will have only one interview and one image report.
I don't know if did the right relation between tables.
-
perfect!
that works to create 1:1, I create individual tables because it a lot of information on each one.
now I have to solve the next problem, how to create a button to open the specific related data in each table?
thanks in advance!
Content aside
- 2 yrs agoLast active
- 4Replies
- 174Views
-
2
Following