I thought I'd run this by you folks BEFORE I start tearing my hair out. I would like a form that shows mailing list type information for a person on the top and a list of activities at the bottom with a check box next to the activities that relate to this particular person. I would like the user to be able to check and uncheck any of these activities.

As I see it, this involves three tables. 1 the person's general data, 2 the list of activities and their descriptions, and 3 all the person IDs and Activity IDs that are checked . I'm figuring the bottom part of the form should be a grid connected to a view of the activity table (#2) with an extra logical field created by a function that looks up the current person's id and the activity id in the 3rd table to see if they are there, returning .t. if yes, .f. if no. Then, I figure I'll have to set up a procedure in the on-click event of the check box in the grid to add a new row or delete one from table #3.

If I'm right so far, all I need is information about how to put a function in a view as a field - I'm not being able to get that to happen easily right now, if I'm way off, please, for heaven's sake, let me know now!!

TIA
Diana