Problem Linking Multiple Fields

[rradelet]

Using CR 8.5 and SQL2000.

TableA has 2 fields:
TableA.Number
TableA.Name

TableB includes the following fields:
TableB.Number1
TableB.Number2
TableB.Number3
TableB.Number4
TableB.Number5

These five fields from TableB represent which employee from TableA completed each stage of an order, and there can be as many as 5 stages to finish an order.

I am trying to write a report that will display the TableB.Number(1-5) that completed each stage as well as the
TableA.Name field (i.e. employee name).

 

[Katy44]

In your database expert, you will need to include 5 copies of table A, each one linked to the fields you mentioned in Table B.

So it would be:

TableA_1.Number linked to TableB.Number1
TableA_2.Number linked to TableB.Number2
TableA_3.Number linked to TableB.Number3
TableA_4.Number linked to TableB.Number4
TableA_5.Number linked to TableB.Number5

then you should be able to use TableA_1.Name etc