Hi everyone
Advice required on following topics please:
Referenceing Inline View MultiColumn
I have looked at the videos and tools and everything is set up, just think its my logicโฆ
I have 2 tables:
Patient Profile (Patient details with PatientID)
Case (Information about their injury)
All data is sensitive so I need to ensure names remain in Patient Profile table and I only refer to PatientID in the Case table.
The issue I am having is that there are many cases for a patient. So I am getting a error that โthere is already a row with that keyโ (the PatientID).
What would be the best way to relate the case to the patient or vice versa?
In the Patient Profile, I would like to see all the cases, with an Inline View or dashboard view. It was showing me a list of cases, but now tells me total of cases but wonโt allow me to go into them individually. I have put a inline view in the bottom of the Patient Profile which allows me to see Cases but not a list.
Also, is there an option to create a MultiColumn which isnโt a key? Or split a field. As I want to keep names to First Name and Surname, but if this isnโt an option, can I split a Full Name into first and surname?
All help idea would be much appreciated.
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |