Jump to content
Salesforce and other SMB Solutions are coming soon. ×

automatically omit items that have previously been selected for the same record


Murph
 Share

Recommended Posts

Hi there,

 

I am new to filemaker and struggling to find a solution to my problem.

 

I have one table with Subject (parent) and another table with Test (child).

 

Each Test is repeated by each Subject at 5 different Timepoints.

 

I would like to set up the Timepoint value list (in the Tests table) in such a way that it automatically omits items (timepoints) that have previously been selected for the same record (Subject), showing only items (timepoints) that remain available.

 

Any easy solution?

 

Many thanks,

 

Murph

Link to comment
Share on other sites

Ahem..I tried but I can't figure out how to make it work in my situation.

 

Scheme of my Database:

- Subject table (parent)

- Test table (child)

 

I create new records in the "Test" table where I can also select the subject (previously created in the "Subject" table) that performs the test.

 

Every subject performs the same test 5 times (5 different timepoints).

 

In the "Test" table there are several fields specific for that test performed by that subject at that timepoint.

 

Every time I create a new record (test) for a subject in the "Test" table, I want to assign to it a specific timepoint that will not show up as a selectable option when creating a new record (test) for the same subject.

 

I hope this make sense.

 

Please help

 

Thanks

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use