Greetings,

I have a file with 3 tables - contacts, events, joiner. The joiner table has the index fields for contacts and events as well as a number of fields I want to be selected by checkbox, for example - accepted invitation, attended, declined, etc.

I created a layout where Events is main table and a portal for contact. This part works fine. I have the checkbox fields, (accepted, attended, decline) in the portal but I cannot edit these. The whole field flashes and that's all it does.

What I want to be able to do is allow the user to quickly go through the contacts in an event and single click on what I'm calling the checkbox field.

Any suggestions?

Thanks

MJ

Do you want to use the entire contacts table each time there is an event and choose from that list?

Thank you for your response.

No, I don't need to use the whole contact table, just the related records in the portal.

IMO, I think that you would better be served by creating 3 seperate number fields that were used as booleans. One value list would be needed that is simply with the value '1'. Then each field would be a checkbox using that value list. Now whenever a certain checkbox is checked, those field value with be 1 and in unchecked, nothing.

It would be easier to do reports this way considering that if you use one field with a checkbox as you do now, you would have to create 3 seperate calc fields with a patterncount anyway for reporting.

As per your suggestion - that's what I already have set up. What's not happening is I cannot edit the field in the portal row.

Any ideas?

Thanks

Could you be a little more specific? Are you getting a message or can you just not do anything with them at all? Is the field behavior set to allow entry in browse mode?

Thanks again for taking the time-

I'm not getting any message - and what's interesting is it's working properly when accessed via IWP.

Again, when using the file locally there is no checkbox appearing for the field and when I click on the area where the checkbox should be I can see the box but it only stays for flash.

When I look at the same layout/ fields via IWP it works.

Strange indeed.

Double check your pen settings (pen pattern, pen width, pen color)

Bullseye. I have to laugh at myself for making such a dopey mistake.

Thanks again for the good call.

MJ