Page 1 of 1
Linking Tables
Posted: Wed Feb 03, 2010 5:37 pm
by 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!!
=> RE: Linking Tables
Posted: Sat Feb 06, 2010 5:45 pm
by 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
==> RE: Linking Tables
Posted: Wed Feb 10, 2010 3:06 pm
by rscott
So selecting the field name is all that^s required for the expression?____Thx
===> RE: Linking Tables
Posted: Wed Feb 10, 2010 3:09 pm
by kfleming
As long as that field^s contents match just the field name will work.____Kathleen__R&R Support