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.
can you post the code you are working with?
I have no code yet I came up with the idea to solve a problem.
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.
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.
let tx := Deliverable first(select 'Control_Table' [Deliverable = tx])
There is no 'Deliverable' field in Emisiones, so this code won't work.
- Status Answered
- 1 yr agoLast active