0

Argument with Ninox AI and reference field

Hi,

I'm new to Ninox and the AI option is just an amazing lifeline

I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached instructions: 

 

"Add a Reference Field:

Click on the "+" button to add a new field.

Choose "Reference" from the list of field types.  

 If it's not immediately visible, you may need to look under "Advanced" or "Relationship" categories.

Name this field InvoiceRef (or any name that makes sense for your setup)." 

 

But there is no option at all to select such a field and AI insists that it is. Can anyone help? I am working on a web version in a trial month

3 replies

null
    • szormpas
    • 3 mths ago
    • Reported - view

    Hi, in order to add a Reference Field, you first have to establish a "many-to-one" relationship.

    Open the edit fields dialog starting from the "child (many)" table, click on the 'Relationship fields' tab, and finally select the "parent (one)"  table from the list.

      • Yoyo_Gam
      • 3 mths ago
      • Reported - view

       I didn't understand it

      "starting from the "child (many)" table"

        I have an invoice table and a payment table and they are a link.

      I must admit that I don't have much experience in this beyond building an accounting system for my business 20 years ago in Access, and even then I didn't have the same experience as today. I have already finished 95% of the application and use the copy paste method . so excuse me in advance for my ignorance.

      • szormpas
      • 3 mths ago
      • Reported - view

        Hi, what is the "link" between the invoice and the payment table?

      Can you discribe in more words what exactly you are trying to accomplish?

      Can you upload a sample database?

Login to reply

Content aside

  • 3 mths agoLast active
  • 3Replies
  • 60Views
  • 2 Following