Jump to content
Claris Platform 2023 Roadmap ×

Another NewB Portal Query


This topic is 6116 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

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....



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.


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.



Link to comment
Share on other sites

This topic is 6116 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
  • Create New...

Important Information

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