Need a Way to Reuse A Field and Get Different Data Each Time

[kc27]

My report uses the fields:
ad_info.ad_nbr, ad_info.ad_desc and ctlg_ad_comp.comp_ad_nbr

An ad_nbr is a number used to track an advertisement, and the ad_desc describes the ad

Ads can be stand-alone ads or they can have other ads assigned to be delivered with them (as in a catalog and other smaller promotional pieces (components) inserted in the catalog).

I have created a report that lists the ads numbers and descriptions of the "main" ad, and underneath it, the ad numbers of those smaller component ads.

Where I get stuck is including the ad description of the smaller ads. That is because the field that describes the component ads is the ad_info.ad_desc field, same as the field that is used for the main ad. I think I need to create a formula for the component ads, something like ctlg_ad_comp.comp_ad_nbr = ad_info.ad_desc

Am I on the right track here? And if so, how would I set up a formula to pull the descripions of the comp_ad_nbr?


Thanks in advance for any ideas on this.

 

[lbass]

Add the ad_info table a second time and rename it ad_info_comp so you know it is being used to decode the comp ads. Then link it to the comp_ad_no. The description field of the new table should reflect the comp ad.

-LB

 

[kc27]

Thank you very much for advice. That got it going for me.