Linking Tables

[rscott]

I^m seeking help to link two tables via the "Relations" option. The first two tabs for Linking Field and Related Table are ok, I think. (Both tables share the same unique field.) ____I get hung up on the next Related Index tab. The table doesn^t have a pre-defined index, and I don^t think linking to the table record number is what I need. The only other option is Flexlink but it calls for an expression which I haven^t a clue what I^m doing.____Any ideas?____Thanks!!

[kfleming]

The flexlink expression needs to match the linking field which should be the field value that is common between the two tables.____So I could have an order table and an order detail table. In the order table I have a field called ORDNO that is a 6 character field. That is my linking field. My related table is DETAIL. I select Flexlink and then in the index expression I select the character field ORDERNO.__It has a different name but the same data type and values as the ORDNO field from the order table. So ORDNO 123 gets matched to__ORDERNO 123.____Hope this example points you in the right direction.____Kathleen__R&R Support

[rscott]

So selecting the field name is all that^s required for the expression?____Thx

[kfleming]

As long as that field^s contents match just the field name will work.____Kathleen__R&R Support