Newbies FMRusty Posted February 20, 2013 Newbies Share Posted February 20, 2013 I have 3 tables Client record Session note Intervention. I want a field in session note to use a checkbox value list to enter text based upon the a field in the intervention table. However, I would like to be able to add intervention descriptions as I go, is it possible to use the "Allow entry of other values" option to add to the Intervention table? If not, how can I solve this. The intervention table is not currently related as I can't work out a logical way to do that. Link to comment Share on other sites More sharing options...
LaRetta Posted February 20, 2013 Share Posted February 20, 2013 Hi FMRusty, We would need to see your relational graph. There is no reason (that I can see) which would prohibit relationship if you use unique relational keys. So also please clarify using similar logic - let's pin this down for you. Is this right? One Client can have multiple Interventions One Intervention can have multiple SessionNotes Can one Intervention involve multiple Clients? ADDED: and can a single Intervention have multiple Session Notes? And what does 'session' mean in relation to Intervention? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4104 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now