Hi,
I have a form (main), for each record(patient), they have a contact against them (sub form contact). I have a button that opens a scores form when clicked. The scores form then relates back to that contact.
So all contact is 1-many with the scores.
Is it possible to have the Button (openScores) highlighted or show in a different colour only when the record related to that contact has records in the scores form.
Eg.
patient 1 has 5 contacts, each contact shows like this...
id, contactDate, notes, OPEN SCORES FORM BUTTON
When that scores form has data in it (relating back to that particular contact), I would like the scores form button to be hightlighted OPEN SCORES FORM BUTTON
Do people understand what I mean?
The reason behind this is, the contact form contains loads of contacts, each shows on the form with the Open scores button on it. When users then try to find a contact with a score, they need to click each button to biew the score form to see if there is any data inside.
By highlighting the buttons if there is data relating to that contact or contactID, it will be easier for users to see which contacts have the scores in and which do not.
Thanks
Will
I have a form (main), for each record(patient), they have a contact against them (sub form contact). I have a button that opens a scores form when clicked. The scores form then relates back to that contact.
So all contact is 1-many with the scores.
Is it possible to have the Button (openScores) highlighted or show in a different colour only when the record related to that contact has records in the scores form.
Eg.
patient 1 has 5 contacts, each contact shows like this...
id, contactDate, notes, OPEN SCORES FORM BUTTON
When that scores form has data in it (relating back to that particular contact), I would like the scores form button to be hightlighted OPEN SCORES FORM BUTTON
Do people understand what I mean?
The reason behind this is, the contact form contains loads of contacts, each shows on the form with the Open scores button on it. When users then try to find a contact with a score, they need to click each button to biew the score form to see if there is any data inside.
By highlighting the buttons if there is data relating to that contact or contactID, it will be easier for users to see which contacts have the scores in and which do not.
Thanks
Will