I am consolidating my 2 earlier posts (http://drupal.org/node/192987 & http://drupal.org/node/192793) to this one. I should have provided more background - so here goes:

I am trying to create a mini database for some patient data (non-confidential) inside drupal.

I have created 2 custom content types:
Patient Record & Follow Up. A Patient Record will be associated with many follow ups.

Patient Record Fields:
Title (set with auto title to 'Patient')
text
text
text

Note here that I was planning to use the Patient NID's as Patient ID's in the next content type.

Follow Up Fields:
Title (set with auto title to 'Follow up')
Patient ID (nodereference field pointing to a view showing the NID's of 'Patients')*
text
text
text

* I used a view as I could see no other way of meaningfully selecting a 'Patient'

Views Set-up:
1. Patient ID's: just a list of NID's of the Patient content types to be used in the Follow up nodereference field (no problems)
2. Patients: A list of Patients with their NID's (labled as Patient ID) and some of the text fields (no problems)
3. Follow Up: A list of Follow ups, suposedly against Patiend ID's (NID of Patient content types). However this field only shows the Patient content type Title, NOT the NID.

Therefore due to the problem with View 3, my whole mini app goes out the window as I need to display Follow Up's against patients. I need to also be able to filter follow ups by Patient ID (NID)

If I could get the node title to be the NID, I think that would solve the issue. Or if I could get the damn views to show the NID of the nodereference field rather than the title.

I have tried using the views fusion module and the nodefamily module but can't get anywhere.

Is Anyone able to help? Suggest another way?

Comments

jody lynn’s picture

Use the views theme wizard (a submodule of views) to retheme your view and get it to display the info you need.

--Zivtech--

gavin_s’s picture

hey Lynn, thanks, I'll give that a go when back at laptop. Does this route require PHP knowledge? Mine is zero :0

gavin_s’s picture

I can't get the views theming to work. It's my lack of PHP knowledge I know.

Is there a simpler way to get the nid parsed directly to a cck node title on submit? I think this would solve my issues.

jody lynn’s picture

OK, without any php, you can instead try the other route you were suggesting: use auto node title module to get the patient node titles to simply be their nid.

--Zivtech--

gavin_s’s picture

Hi Lynn - I've been trying that but am missing the majic command/setting to do so. What would the code be to do that? So close...... :)