Map columns dynamically (1 Viewer)

[Ben_Entrew]

Hi all,

got the following issue:

There are two tables A und B.

Table B contains columns like 1FC, 2FC,...., 12 FC

standing for forecast sale quantities.

Now I want the user to decide how many FC columns he wants, always starting with 1FC.

Let's say he wants three FC columns.

Now I want to map these 3 FC columns to the table A.

Both tables contain column Product_Classes.

How can I realize this?

Can I shrink table B to the 3 FC columns ?

Thanks in advance.

Regards,
Ben

 

[Ben_Entrew]

Is there some kind of container where I can put all columns I want to,

then I could map the columns of table B with the available columns of that container ?


Regards,
Ben

 

[gemma-the-husky]

why not have another table, or a collection to hold details of the columns you want. It will still need a bit of work, I think, though.

 

[Galaxiom]

Your table structure is not what it should be.

The FC values should all be in a single field. Another field should hold the informamation that currently separates the data into different fields.

One you correct this you won't have issues with querying different numbers of fields because the selection becomes a matter of a criteria on a field.