Recent content by GaP42

If a student can belong to one and only one homeroom (at any one point in time) then Attempt B is the correct structure. If you need to retain the homeroom a student was allocated to - say from one year to the next - then Attempt A is more appropriate, however you will need at least an indicator...

1. Technical expertise is not a requirement the moderator of moderators. They provide an oversight view of the "civility" of moderator responses, which we all hope the moderators display. Acknowledgement of issues and processes for de/escalation, in view of AWF/ and incident log / action I would...

Happy Birthday! ditto to Gasman's comment.

Even for small orgs a business continuity plan is needed - not just for the IT systems. Fires and floods can affect physical records too! and then who is the back up for performing roles if key personnel are lost without warning? And then you have to maintain the plan, check it is workable and...

Referring to the doc management app you built @BlueSpruce these are some observations that you might want to consider On checking out the application here are a few observations/criticisms and personal recommendations: 1. Schema: the Document table has two fields: DocumentStorageLocation and...

When typing in the notes section it appears you are adding that note to a current record (which has no product identified). Is that what you want to do? (I would expect some validation to prevent that occurring). The record should be saved when moving focus off that record (with validation). As...

Irrespective of expertise in Access, what you have is a problem with the design of the database, as the above statement illuminates the issue. The development of a database requires that analysis is performed to determine how best to store the data to minimize redundancy, remove ambiguity in...

How would "Date of service" relate to some of these doc types? Effective date? Date of document creation, Date registered in application? And how would you want to handle update / replacements eg wills, advanced care directives. Do you wish to be able to enable a master document to have related...

Can documents be categorised as both medical and financial or ... ? Is a medical certificate/ health fund membership a credential? As this is a patient populated record of documents, the categorization is probably best focused on simplicity.

Yep - my misread - I can only blame the hay fever I have atm. The ID in tblContact_categories is superfluous as you suggested, if it is not defined as the PK rather than the existing composite PK.

It is the Contactid in tblcontacts that is superfluous, given your explanation above, not the ContactID in tblcontact_categories. There it is used as FK to resolve the N:N relationship of contacts to categories.

BTW Category type in tblContact_Category appears to be redundant - it should be removed as you have it in tblCategoryTypes. Re the query - think of it as two sets of data - one for bikes and one for cars - and yuo need the intersection of the two sets.

Yes, the sensitivities of personal health information (and consequent regulation), as well as the breadth and depth of health data makes interoperability extremely complex. While your application is simply to provide a (set) of health documents, they remain outside the commercial EHR...

So this is an application that the healthcare patients use - they supply the docs (through scanning, attaching), and review and then may send those to a medical record - is that external? If so the process for accepting such records may/will need stringent verification/validation, which may...

Glad to help you. You should evaluate it carefully and I would expect some questions to be raised as you work with it - as I do :) (case in point: the decision about how you choose to implement txApplied and the associated MedicationDetail, Procedure and VaxGiven tables as these have 1:1...