0

creating linked records from table A to tables B and C question

Is it possible to do the following:

 

From table A (button) script the created of a new record in Table B (easy), then create a record in Table C that is linked to Table C

Table B is an "office hours" table

Table C is an appointments table

 

B:C :: 1:N

7 replies

null
    • Fred
    • 10 mths ago
    • Reported - view

    can you post the code you that does Table B? we can use that to build the code for Table C.

    • Fred
    • 10 mths ago
    • Reported - view

    You can try something like:

    let t := this;
    let newB := create TableB;
    newB.TableA := t;
    let newC := create TableC;
    newC.TableB := newB
    
      • Roger.1
      • 10 mths ago
      • Reported - view

       

      Thank you so much, Fred.
      Stuck here for a while, finally solved.
      I always overcomplicated it, wanted to select every single data from A and then link to B, etc.

      It's actually as simple as your example, just A=B and B=C

      • Fred
      • 10 mths ago
      • Reported - view

      If you are satisfied with the answer, please mark the post "answered" so others who are looking will know if they should look at the post.

      • Roger.1
      • 10 mths ago
      • Reported - view

       I'd like to, but seems only the host are able to, I am just a follower😅

      • Fred
      • 10 mths ago
      • Reported - view

      you are correct. sorry, I thought you were to original poster.

    • NYNNA
    • Louis_Cornacchia
    • 10 mths ago
    • Reported - view

    Fred, thank you for taking the time to answer questions. Your

    answers are very helpful. 

Content aside

  • Status Answered
  • 10 mths agoLast active
  • 7Replies
  • 100Views
  • 3 Following