Jump to content

Recommended Posts

Posted (edited)

Hello I hope all is well and everyone is safe


I have a dilemma I hope someone could help me I have been trying to figure it out but with all the video watching and reading and searching I have no Joy

I have a

Table for Contacts

Table for Analytical

Table for Samples

I have joined them witch all works fine but here is my dilemma

On the data Entry Screen I have my samples on my portal to be tested and then I click the popover to test the sample and choose the correct method I have used for the sample result. As you can see on the screenshot one test is Chrysotile / and the other is Amosite /

But I may have to examine the sample again until I get the right result I have highlighted the fields in yellow on the database relationship image what needs to be retested if needs be??? But one sample could be tested several times

I can’t figure out on how can I store the data from the first test then retest the same fields until the correct result.

But each test has to be saved for Inspections for out certification.

I hope you can understand what I mean???

Thank You




Edited by extreme
Link to post
Share on other sites
Posted (edited)

The only part I could understand is this:

12 hours ago, extreme said:

one sample could be tested several times

This describes a one-to-many relationship between samples and tests. I didn't understand what the other tables do, but it doesn't seem like you have a table that would hold a record for each instance of a test being performed on a sample. It's also possible that such table needs to be a join table between samples and a table of test types.

In any case, I believe that what you describe is a problem of structure, not scripting or user interface (though these could come later).


Edited by comment
Link to post
Share on other sites

Hello Thank you for trying to understand I know it hard to view other work especially when I am still trying to learn. So I am sorry for any confusion.

The first screen Analytical Data Entry is for the address where the samples came from and the Company who has taken the samples for us to test. That is the T40_Analytical 

On the Table T50a_analytical_SAMPLES|id_sample which as a join table from T40_Analytical = ID_Analytical

The T50a_analytical_SAMPLES|id_sample is where the samples are being tested all the hi lighted yellow ones are the types of test we have to do these are the ones we sometimes need to re-test

The T50_Samples are the same as T50a_analytical_SAMPLES|id_sample

I am not sure how the best way to do this I know that it is a one to many relationship.

So any help would be gratful even if I need the change it Im stock on this :)

Thank you

Link to post
Share on other sites
Posted (edited)

I am afraid I am not able to follow any of this. Let me suggest two things that may help you to figure this out for yourself and also to explain it to others, if necessary:

  1. Start with an ERD and put aside all layout and or UI considerations until you have a good one. Note that an ERD is not RG: every table needs only one occurrence;
  2. Name your tables after the real-life objects they represent (for example, if you have a table "for the address where the samples came from and the Company who has taken the samples for us to test", name it SampleSources or Companies or Addresses or something like that).


Edited by comment
Link to post
Share on other sites

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.