Add a column header and column to a form table control when

[coldspring]

Hi All

I would think this would be easy, but I can not figure it out. Can someone point me in the right direction.

I would like to add a column header and column to a form table control when based on data in separate table.


Here is the problem

I am building a database to hold parametric design data. These are basically a set of 2D charts of tables that are interrelated.

For example parametric design can be used to scope an aircraft design. It does not give you the exact answer but it does limit the area you have to look. There is an old saying in the aircraft design business "you can have it faster, lighter or cheaper .. pick two". So the set of parametric carts would look like this:

Cost vs Weight
Weight vs Performance
Performance vs Mission


All of the above parameters are in a data base table containing the parameter TYPE, NAME and a set of attributes. The table might look something like this:

Pid Ptype Name at1 at2 atN
1 Cost foo foo1 foo2 fooN
2 Weight boo boo1 boo2 booN
3 Weight goo goo1 goo2 gooN
4 Perform hoo hoo1 hoo2 hooN
4 Cost moo moo1 moo2 mooN


I want to track the relationship between Parameter1 (Pid1) and Parameter (Pid2) for given parameter pairs ie Cost vs Weight or Weight Vs Performance.

So I have a table of relationships that looks like this:

LinkID PidFROM PidTo atr1 atr2 ... atrN
1 1 2
2 2 4
3 3 4
4
n


This says there is a relationship between the Cost parameter named foo and the Weight Parameter named boo. Cost foo dos not have a relationship with weight goo. Both Weight parameters boo & goo have a relationship with the performance parameter hoo.
Finally the Cost Parameter moo is not effected by any of the weight parameters. I also have additional room of attributes about the relationship.

I have built this database and it works great!

FINALLY MY QUESTION!

I would like to make a dynamic table form control on a subform such that I can enter a type name such as cost in main form and I would populate a form table control that displays all the cost names in the first column of the table and all the Weight names across the top row. I then plan to use the table to update and display information from the link table.


I thought this was something people would do all the time; Kind of like a Consumer Reports or product vs features comparison table. But I can not find a single example.

Can anyone help.

Chris

I would like this table to be dynamics so that when I add a cost parameter name or a weight parameter name the table updates with the latest information.