Jump to content

Another NewB Portal Query


PathGeek
 Share

This topic is 5755 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Situation: A laboratory setting, in which

Patients (with personal information) need one of 3 types of Tests (with information). One Test (A) at times requires SecondLevel Testing (results are distinct but must later be analyzed jointly).

I created tables:


  • PatientInfo
    TestA
    testA1
    testA2
    testA3
    TestB
    TestC

I need a layout (based on PatientInfo)

that will

a) allow me to create a Test (A,B or C) through a portal

:o disallow the creation of the other 2 tests once the serial number has been used for another top level test and still allow me to create a sublevel test with the same number....

Clear?

Example:

Patient1 (Joe Smith) entered in PatientInfo layout

needs "TestA".. . need portal to create Patient1_TestA. This must disallow entry of Patient1 into TestB or Test C

If result Patient1_TestA requires it, must be able to do similar at next sublevel.

I have the portal and can create TestA

I don't know how to restrict further Tests from being created.

TIA

Link to comment
Share on other sites

My thoughts goes this way - instead of validating would I strain the options dynamically....

The way it works, is to create a new record and option {a,b,c} shows up in the right portal, then after one of the buttons have been pressed the portal changes.

I do not think the number of tables originally suggested are justified, since as they are in my table ...are pretty similar in content, you could always make a subsummary report or some selfjoin relation to make the grouping of the data required.

--sd

TestofPatients.zip

Link to comment
Share on other sites

This topic is 5755 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.