I am a kidney patient, and have been for the last 24 years (21 of which were at home on a kidney dialysis machine � having had a transplant since). Although a have computer experience, I am not a programmer, however about 8-10 years ago I wrote a database for the Renal technicians for patients and their associated kidney machines in Alpha4v4 (DOS). This worked well until a new PC was required with Windows 2000. I have now been forced to rewrite this with all the new functions\facilities of Alpha 5 in Windows. My problem is as follows:-
I have a Primary table called machines and a child table called patients as a one to one. These are Dialysis patients who are linked to a single coded kidney dialysis machine. The link field is called machine code, and both tables have a field called surname. I want to be able to either change the machine code to another patient or the patient surname to another machine using the post function on editing either table. It could be the machine has moved to the workshop for repair, or the patient has died or had a transplant. The machine then needs to then be attached to another record\patient etc. The machine table also has further child tables attached, repairs to each machine on a one to many basis etc. Where as, the patient (child) table has water samples on one to many (this relates to samples at their home and not the machine). I originally had these tables all in one set, and have tried since with them split into separate machine and patients.
DO I HAVE A PROBLEM WITH THE LINK FIELDS OR IS THERE AN EASY WAY TO MAKE THIS POSTING ROUTINE WORK?
I have a Primary table called machines and a child table called patients as a one to one. These are Dialysis patients who are linked to a single coded kidney dialysis machine. The link field is called machine code, and both tables have a field called surname. I want to be able to either change the machine code to another patient or the patient surname to another machine using the post function on editing either table. It could be the machine has moved to the workshop for repair, or the patient has died or had a transplant. The machine then needs to then be attached to another record\patient etc. The machine table also has further child tables attached, repairs to each machine on a one to many basis etc. Where as, the patient (child) table has water samples on one to many (this relates to samples at their home and not the machine). I originally had these tables all in one set, and have tried since with them split into separate machine and patients.
DO I HAVE A PROBLEM WITH THE LINK FIELDS OR IS THERE AN EASY WAY TO MAKE THIS POSTING ROUTINE WORK?
Comment