Hello, hope you can help me.

I have one DB where I have customer info (Table A). In another table I have a satisfaction questionaire (Table :. This last file can have several records for each customer and the difference is the date it was applyied and results. I have some sumary fields that grade the questions.

I have a layout in Table A where I would like to show the summary fields from table B by poping up the different dates that the questionaire was applyied and when selected to show the results (fields from table :

I have created a relationship customerid=:customerid

Can you help?. I know this maybe a basic question. I have read a lot through the forum and tryed some things. This one I havent been able to solve without bothering.

Thanks, Dan.

Mexico

Hi!

Make a calculation field in Table a with choosen date AND customerid and then in Table B make a similar calculation field. Then make a new relationship, between the two calculated fields.