The best way to update two linked tables - Help 
Author Message
 The best way to update two linked tables - Help

Hi folks,
I have two tables related to each other. One of them is the register
of a patient in a psychiatric hospital, with a lot of informations.
The other is the register of the medications he is having. We
assume that no more than 10 medications is possible per
patient. So, the question is, which is the best way to update the
patient's medication registers?

I am thinking in load the medicaments in a table in memory and
then compare with the updates the user has made in the screen.
So, I will have to delete the medicaments that are no more present,
include the new ones, and modify the data of those who has changed.
But, is this the best solution?

Thanks for your help.

Sun, 18 Feb 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help: updating text file-Updating Data in a linked table not supported by this ISAM

2. Linking two Access tables in two databases

3. Linking two tables from two diferent databases.

4. Help writing Update between two tables

5. Comparing two tables and then updating one table.

6. PLEASE Help with updating two tables

7. Help on updating two tables

8. PLEEAASSEE!! Help on updating two tables

9. The best way for linking two programs?

10. Updating Links in Word 2002, Edit, Links, Select Update Method

11. Linking two different tables on one form WITHOUT using Data Environment Deisgner

12. Linking tables on two seperate databases - how?


Powered by phpBB® Forum Software