Is there a way to do a Match & Index to assaign to a field

[gabber4858]

Is there a way to do a match and index from values from one table and relate it to another table's field?

I want my my first table to look like this:

BoardLocation 01 02 03
01A01 22419 22420 22421
01A02 22519 22520 22521

Return 01A01-01 has 22419 in the field, 01A01-02 is 22420

I also want to be able to link another table to the index position, not the field at the index intersection.

RiserPair Port Number
1 01A01-01 22419
2 01A02-03 22521
3 01A01-02 22420

Is this possible? Thanks

 

[bborissov]

Better design your first table to look like this:
[tt]
BoardLocation Number Value
-------------------------------
01A01 01 22419
01A01 02 22420
01A01 03 22421
01A02 01 22519
01A02 02 22520
01A02 03 22521
[/code]

What if after sometime you need more than 3 additional fields?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gabber4858]

My problem is this: BoardLocation is a slot where cards are inserted to the backbone of the sytem. Depending on the card type, it can have 16 to 24 ports. There are thousands of cards and they get swapped out frequently. For my table, I will have a column with a bool value "16 or 24" so I can make a query that ignores the unused ports depending on the card type. Does this make sense? Its a weird table, I know.