X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Northwind Students Extension - Referring To Table Twice, Access 2016    
post Jun 13 2018, 08:25 PM

Posts: 182
Joined: 3-July 06
From: New York, NY

Context: Extension of the Northwind Students Database
Problem: Can't update the Guardian field on the Primary tab of the Member Details form (frmMemberDetails, subform is frmMDPrimary)
Likely error: qryRelationships

So I started the the Students database. I replaced Student objects with Member objects.
I also prefixed the new things tbl/qry/frm.
The original system had Students-S&G-Guardians. I have a new qryRelationships object that associates Members-Relationships-Members_1.

The idea is if I have two members, Jane and John Jones, I want to know they are associated.
If Jane is primary, I want to enter Jane in the Guardian field on the John's Member Detail form, on the Primary tab.

However, I guess the relationship I have set up won't allow for that. I get the dropdown but the field isn't editable.
Any advice on how to make this kind of recursive relationship work? I don't want to have to enter members on two forms.


Attached File(s)
Attached File  nw_students2.zip ( 283.6K )Number of downloads: 8
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    17th June 2019 - 05:44 AM