Hi! Help me!![:(][:(] I have made a new table (NEW TABLE 90003) and I want to transfer fields data from original Navision table 14(location) and table 18(Customer) there. I need to transfer all information which are stored in field CODE from table 14(Location), and also all informations which are stored in field NAME from table 18 (customer) in the my new table. I want that my the new table have fields (CODE) from table 14, and also the field (NAME) from table 18. How can I do that? Thanks a lot.
I assume the two bits of data (Code field from Location and Name field from Customer tables) aren’t related?!?!?!
And what exactly is your problem[?] Defining the fields or transferring data? The fields could be defined as 1 Code Code10 2 Name Text30 Transferring data between single records can be done with simple field assignments, or TRANSFERFIELDS as long as field numbers and definitions match. If you want to copy (read: merge) the entire tables (14 and 18), you need a report - but you must decide what locations to combine with which customer. In case of a “table product” the report is rather easy: A data items for table 14 and a nested data item for 18. More details, please…
I want to make a new table in which would be fields No., First Name, Last Name, Job title from table Employee(5200) for example.
Hi Perhaps this lead you to a solution: Declare MyTable as record Employee.Find('-'); Repeat MyTable.Init; MyTable.No:= Employee.No; MyTable.LastName:= Embloyee.LastName; MyTable.FirstName:= Embloyee.FirstName; MyTable.JobTitle:= Embloyee.JobTitle; MyTable.Insert; Until Employee.Next = 0; I would suggest you to ask your NSC for a training on this. You can run into a lot of trouble if you don’t know exactly what you are doing [B)]. bye André