Join Problem. 2 fields lookup-table

[auspac]

I am using R&R Report Works. Latest Edition.__The database i am using is an Access2000 .mdb__I have a Table --> FoRego__Fields are __Category C6__Feature C6__I need to Lookup a Table Fofeat, for each record in Forego__Fields are __Category C6__Feature C6__I have an Index which contains both Category&Feature in Fofeat__??How do i do a Join as follows__Say a Calculated field called Lookf Forego.Category+Forego.Feature__Looking up Fofeat . But i need to look at a combined lookup eg__fofeat.category+fofeat.feature.__ie. i am trying to find a match if only the category&feature are the same.__In the join i seem to only be able to get the join to acces a single field,., not the combined category+feature.__Is this possible.??__OR.. is there a better way !!!!____Appreciate some help__

[kfleming]

Select the first field in the join dialog.__Then click the Options button. It will bring up a box below with your first join field. You then use the selectors above to add the second join field. You can then click below and the bottom box to add any additional join fields.____Kathleen__R&R Support

[auspac]

[updated:LAST EDITED ON Jun-10-05 AT 04:55 PM (EST)]Kathleen,____Thanks for the help, all working ok now.__I think i have been using R&R Dos for too long!!, still thinking this way.!!!!____Regards Auspac