Jump to content
Sign in to follow this  
reynir

Relationship for popover

Recommended Posts

reynir    0

Hi

 

I am developing a database for measurements of samples.  

 

Each sample has one or more measurements.

 

Each measurement has one or more work items

 

When a sample arrives I add one or more measurements to the sample.

 

For each measurement I copy work items to a table "Work items in a sample" and for this record I log start time and also time when the work item in sample is finished and the result for the work item.

 

I have a list of work items in sample which are not finished and every time each work items in sample is finished I update the list.

 

So if a measurement has 5 work items in sample and 2 are finished I only see 3 in the list.  

 

I want to see in a popover all work items in sample to compare the results of the finished with the unfinished.

 

When I create a portal in the popover and try to show records from work items in sample the work items in sample table is grayed out.

 

I have tried to make a self-join "Work items in sample::id" = "Work items in sample::id" but I only get one work item in sample

 

The popover shows correct sample number and measurement name in each record.

 

Hope you understand my problem.

 

Best regards from windy Iceland.

Reynir.

Share this post


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

Sign in to follow this  

×

Important Information

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