Setting fields and add rec

[snekkis]

This question it based on concordance between Standard Industry Classification Code - SIC and equal european code, NACE.

I have tableA (1700 records) and tableB (700 records). They both have a field with the same value, ValueA.

TableB has ValueB, and it is empty in tableA. I want to export ValueB in tableB to ValueB in tableA based on the same valueA in both tables.

TableB has several records with different ValueB, but the same ValueA. I want them also inside tableA with a new record based on the same valueA in both tables with all the other record values in tableA.

Please, anyone?

[LaRetta]

Hi snekkis,

Please explain your situation in regular words instead of using Table A and Value B. It is much easier to understand if we have a vision of the purpose and context. It seems you are duplicating data when you might be able to simply relate it (on value A?). With a bit more information, I'm confident that we can help you out.

LaRetta

[snekkis]

Well, for the tables I must use A and B.

Table A, with 1700 records contain several fields. The most important, I called SIC_code. The other fields contain imformation about the SIC_code.

Table B also contain a SIC_code field, which could work as a relation field. This table also contain a important field called NACE. It is the concordance or conversion value to the SIC_Code. The whole idea is to bring this NACE over to table A. Using the relation it would be easy to relate it and bring it over. So I thought, but the problem is that there are several equal SIC_code fields. There are several different NACE records with the same SIC_code.

Table A (1700 records)SIC_code field

Table B (700 records)SIC_code field & NACE field

In a portal row with records from table B, I could get up to 6 records with the same NACE. I need them inside table A, but then I need to create a new record in table A to place the NACE code. But in that new record, I also need the rest of the SIC_code information from the relating SIC_code record(This is a nightmare to explain, I dont know if I made it clearer. Sorry!).

Snekkis

[David Jondreau]

You've got two tables, SIC_Codes (1700 records) and NACE_Codes (700 records). From your description so far, it sounds like you want each NACE record to be represented in the SIC table.

Why? What is the NACE table lacking? What are you going to use it for?

Sometimes what seems like a technical problem (how do you move data from one table to another) is really a strategic one. What are you trying to accomplish in the real world?

Edited December 10, 2007 by Guest

[snekkis]

Nace codes are European industrial classification. SIC codes are US. When I look up the SIC code in table A, I get the explenation on that perticular SIC code, but I do not know what the equal European NACE code would be. In table B, I have that right conversion, but I do not have the explenation of the SIC code as I have in table B.

I suggest nobody spend more time on this Q. I am so far from an amswer because I am not able to explain the problem, but thanks anyway.

Snekkis

[David Jondreau]

I suggest nobody spend more time on this Q. I am so far from an amswer because I am not able to explain the problem, but thanks anyway.

Snekkis

Not so fast, Snekkis. You're almost there. If you had said all this in your original post, you'd already have an answer.

Nace codes are European industrial classification. SIC codes are US. When I look up the SIC code in table A, I get the explenation on that perticular SIC code, but I do not know what the equal European NACE code would be. In table B, I have that right conversion, but I do not have the explenation of the SIC code as I have in table B.

What you need to do is NOT add records anywhere. You have all the information you need, you just need to make the connections between the two tables. Relate the SIC table to the NACE table via the SIC code. That allows the SIC table to 'see' the NACE table.

You're using FM 6 which I'm not very familiar with, so I don't think I can help you any more, but one issue you'll come across is that if you have 6 NACE codes for one SIC code, do you want to see all NACE codes or just 1 or what?