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
8 replies
-
can you post the code you are working with?
-
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,
-
-
I have no code yet I came up with the idea to solve a problem.
-
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.
-
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.
-
Fred Again sorry, but it doesn't work at all, Let's forgegt this for a while.
Thanks for your time
-
Content aside
- Status Answered
- 1 yr agoLast active
- 8Replies
- 100Views
-
2
Following