Please help with calculation field

[Ronzues]

Here is the deal,

I have a database of advertisers who have purchased magazine ads. I want to be able to do a find for an advertiser and in the found set have a field that will show which magazines they have purchased an ad in before.

I did this with a portal which I think worked very well however this ridiculous overdemanding boss of mine didn't like it because the portal showed every ad they had ever bought, meaning that if they bought an ad in one publication 10 times then that same publication showed 10 times in the portal. She wants the field to show only one occurance of each publication even if they bought 10 ads in the same publication at different times. Also she wants the field to display only one occurance of every publication that they ever bought from us.

Can anyone point me in the right direction?

[Kent Searight]

Go to Post#180133. It's very similar to what you want to do and the solution is essentially the same.

[denisg]

I have a number field that the user just enters 8-10 integars. Now I want to

1. test for 10 integars; if not equal to 10 integars, the user is promted yet allowed to enter less than 10 integars.

2. I also want to preserve the data in the original field-I don't want to loose it-I understand if I change the field to a calculation, etc...the previous data is lost-need to preserve.

Mac OS X server running FM 5.5

can someone help...Thanks, Denis

[LaRetta]

Hi there! I just wanted to let you know I deleted your identical post in Layouts. It is only necessary to post your question in one place.

I have confidence someone will help you shortly.

LaRetta