0

get data from another table in the same database

Good evening,

I have a NINOX database with two tables called Project and principal. The relation between the tables: from principal to Project.

When I choose a principal in the project-form, I would like to get the adress and city of the principal in the project-form too.

How can I manage this?

Thanks a lot!

 

Kees

1 reply

null
    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    example

    main table customers

    related table Jobbags

    in jobbags there is a field called address

    script

    'address' := 'customers'.Address

    this will do the look up to the related parent table

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 1Replies
  • 452Views