0

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

null
    • Fred
    • 2 yrs ago
    • Reported - view

    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.

    • Fred
    • 2 yrs ago
    • Reported - view

    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.

    • Cirugia_Toracica
    • 2 yrs ago
    • Reported - view

    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. 

    • Cirugia_Toracica
    • 2 yrs ago
    • Reported - view

    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!

Login to reply

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 149Views
  • 2 Following