Hi -
I have another one that I would like to resolve the most effecient way.

I have 2 tables:
Table 1 has x fields: one of the fields being trannumber
Table 2 has 3 number of fields: trannumber , sort_order , details

Table 2 has an index on trannumber
Table 1 is the parent, table 2 is the child
Table 2 is related to table 1

I would like to set up a relationship between table1 and table2 whereby table 2 is sorted by the field sort_order. The problem I am having, is the key-relationship to perform the parent/child is on trannumber.

FYI: Both these tables can be extremely large.

PLease can someone advise?

Thanks,

Larry