0

Script for transfer record N:1

I had to create an additiona table with relation N:1.

Table A Reference N:1 to Table B On Table A now I have records included and I need to Include them in the Tabke B, isthere any scripts to do that.

Thanks

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    can you post the code you are working with?

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      Fred Hi Fred

      Table CONTROL_TABLE Emisiones (Issues to Clientb) come from the Documents with Issues, now create, a Table EMISIONES (Reference from EMISIONES TO CONTROL_TABLE 1:N), but these is empty and I need to Add Existing Record one by one.

      I have 3 tabs with Issues by weeks, I select the Week and I can saw the Documentos on Issues A, B and 0,  

      Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    I have no code yet I came up with the idea to solve a problem.

    Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

     Fred

    Hi Fred I try with this formula 

    let tx := Text
    
    first(select Emisiones [Text = tx])
    

    Have the Tables ControlTable an Emisiones N:1

    On update multiple records & Emisones I place the Formula but don't work. Now I'm doing dor one register but need for more registers.

    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    I'm looking at your DB and I don't know what you want done. You have two records in Control_Table and 1 record in Emisiones. Do you want to link the two records to the 1 record?

    If so then the field you are using (Text) won't help since the field Text in Emisiones is blank. If I put the letter "A" in it then run your script it all works.

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      Fred So sorry Fred, I send the correct DB.

    • Fred
    • Fred
    • 2 mths ago
    • Reported - view
    let tx := Deliverable
    first(select 'Control_Table' [Deliverable = tx])
    

    There is no 'Deliverable' field in Emisiones, so this code won't work.

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      Fred Again sorry, but it doesn't work at all, Let's forgegt this for a while.

      Thanks for your time 👍

      Like
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 8Replies
  • 56Views
  • 2 Following