AnsweredAssumed Answered

re: related tables

Question asked by mark_d2x on Jun 12, 2009
Latest reply on Jun 15, 2009 by mark_d2x

Title

re: related tables

Post

Hi,

 

Just having a problem setting up a new database.

 

I have 4 tables each with a key primary and key foreign.

 

Here is how it is set up

 

Patient -     _kp_patient

 

Tumour -     _kp_tumour

                 _kf_patient

 

Treatment - _kp_treatment

_kf_ tumour

 

Follow up - _kp_follow up

_kf_tumour

 

These are all set up as a relationship - so that records can be made from this relationship.  For each patient you can have more than 1 tumour and more than 1 treatment for that tumour hence setting up the database in this way.  Or have I managed to do that wrong?

 

Okay here is the problem, I can set up the first layout for the Patient (based on Patient table), what I am not clear about is the next stage.  I want to then add buttons to take you to a new layout for Tumour or  Treatment; Follow up can be done using a portal.  Do I create the other tables based on the Patient or Tumour and Treatment? If I do it this way I will need to add a button that adds a new record to the Tumour or Treatment table rather than the Patient. 

 

I am ok adding a button to get to another layout for navigation.

 

Many thanks

 

Mark 

 

I hope that is clear?  

 

 

Outcomes