Need info from table that stores #'s

[maggielady]

I have two tables, a family table and lookup table. In my report I want to include the family status field from the family table. I have the two tables linked by status id but in the both tables it's a number. There is a text field in the lookup table that gives the corresponding text for the #. The question is what if a person adds another status in the family table? It will go to the lookup table but if I use an if statement to get the text from the lookup table, I couldn't possibly know all the numbers that may be created for the family status. I need a formula that will pick up any added status id #'s and get the text from the lookup table. Any help would be greatly appreciated!

 

[synapsevampire]

If you link the tables, and the Family has multiple entries, you'll get the correct corresponding lookup values without any coding, just drop the field in the report.

Group by the Family, and place the status text in the details, all of them should be listed.

If not, give an example of the fields in the tables, and what the data looks like, and how you want the report to look.

-k

 

[maggielady]

synapsevampire, THANKS, not sure where my head was, that worked GREAT! THANKS again!