How to code master detail relation in tabforms

[AshokS]

Dear forum member,

Can you tell me how to program a master detail relation in the Ms Access tabforms?

The master form is a patient forum, with all information of a patient.



The detail subform (a tabform) holds the related patient information, such as phone numbers.

Question:
If I click on a patient in the master form, I would like to see the related phone numbers in the subform.

Can you tell me which trigger should be programmed and how to program this behavior?

Many thanks.

regards

Ashok

[pbaldy]

Generally this does not need to be coded. The master/child links are properties of the subform control; they would usually be set when the subform is added (the wizard will ask about linking fields, or they can be set manually).

[AshokS]

In the tabpages wizard, the master detail relation is not automatically set by the wizard. IN the subform is is indeed automatically set.

Can I send you the screens / forms or access file?

regards
Ashok

[pbaldy]

Not sure what you mean. Tab controls are irrelevant regarding master/child links, as a tab control has nothing to do with data itself. Perhaps it would make more sense for you to post your db, or a sample of what you're trying to do.

[AshokS]

Hello Paul, please find attached the db file.

If you open the file, you will see in the left under corner a form "TabPatienten".

Open it in the designmode.

Then you will see different tabforms. The first tabform is 'Patienten' and the second one is 'Verzekeringsgegevens'. Patienten is the master form whereas 'Verzekeringsgegevens' is the detail form. So whenever a patient record gets the focus or is clicked on, its related detail 'verzekeringsgegevens' should be shown if the user clicks on that tabform.

I woud much appreciate if you can show me how to program the code for these two forms or how to develop the master -detail relation between these two forms.

If successfull, I will then do the same for the other tabforms.

Many thanks.

regards

Ashok

[RuralGuy]

It would be very helpful if you define the relationships each table has with the others. You have 4 different SubForms that you are trying to keep in sync. That can be a bit tricky. Will everything drive off of the 1st tab or can the user switch by using one of the other tabs?

[AshokS]

The relationship between the tables:

1) The first tabel is 'tblPatienten'. This table is related with the first tabpage, the master form

2) All other tables are detail tables related with only the master table tblPatienten:

TblPatienten and TblGeldigheidVerzekering have a 1 to many relationship. TblGeldigheidVerzekering is related with tabform 'Verzekeringsgegevens'

TblPatienten and tblGarantiebrieven have a 1 to many relationship.
tblGarantiebrieven is related with tabform 'Garantiebrieven'

and so on.

3) What behavior I would like to program? Only when a patient is selected in the first tabform or a record gets the focus, the detailforms (verzekeringsgegevens, garantiebrieven etc) should also show the related record. If a record is selected in one of the detail forms, no changes should be made in the other tabforms.

4) I can tell you that the relationships at datamodel level are all well defined. The only thing I cannot get done, is the master detail relation in the tabforms.

Let me know if it is clear now.

Regards

Ashok

[RuralGuy]

You can define these relationships in the Relationship menu and then we could all see what you are talking about.

[AshokS]

please see attached the db file. IN this file you can read the relationships between defined tables.
thx
regards
Ashok

[RuralGuy]

Thank you. Much clearer. FYI, it is much easier to understand if you name the ForeignKeys the same name as in the table where they are a PrimaryKey. A descriptive name is also a benefit such as PatientenID rather than just ID. You've got them mixed in this db but it is now understandable. I'll do a little studying.

[AshokS]

Thanks for the tip, I will make those changes...foreignkeys and primary keys
looking for your response
regards
Ashok

[AshokS]

Paul, I will log into the forum at 08 o clock in the morning again. It is already 1:30 in the morning in Suriname, time to go sleeping.
thx, regards
Ashok

[RuralGuy]

Good night!

[RuralGuy]

See if this is what you had in mind. It is done with an invisible control on the 1st tab and then the LinkChild/MasterFields propeties of the SubForms.

[pbaldy]

Paul, I will ...

Excellent! Allan is doing all the heavy lifting and I'm getting the credit!