ContributionsMost RecentMost LikesSolutionsRe: Enforce single use of a record in a relationshipThank you. I posted some clarification and new information given to me tonight. It is outside of my original question. I need to relook at what we were going to put together for it and see if I can come up with something that will work but if not I will see if they will give me an allowance for outside assistance and reach out to you via your website. Thank you again for taking the time to look at this.Re: Enforce single use of a record in a relationshipThank you both! It is actually combining 5 different samples to create a new single sample. Each of the 5 samples has specific characteristics(data) and we are wanting to combine the 5 to create a unique new sample with a new set of characteristics. Some will be measured and some will be through calculations based on data associated with each of the 5 samples used. Now some new information as I discussed the suggestions with the project manager this evening was that they want us to be able to use the newly created samples in future combinations as one of the 5 samples used to create a new combination. Same rules apply that once a unique sample is used in a combination it can no longer be used in any future combinations. All samples, including those created through the combination, have a unique 8 digit text serial #. This is getting outside the scope of what I was asking in the initial question and I need to re-evaluate the app. If you have any further thoughts I am always grateful for any advice/help. Either way, Thank you both for your time and thoughts! Re: Enforce single use of a record in a relationshipI think Yearend has fried my brain, so apologize for the constant clarifications. Of course, you are correct the child is not required to have a parent. I have played around with a couple of different ways. If I do a Two Table setup I don't see how to select existing data into the parent. Is it just manually creating a blank parent and then going to a report on the child table that filters out any with an existing parent and adding the new parentID? Is there a way to do thatdirectly from the parent? Using 3 tables it appears to work by using a filtered report in the join to filter out any that have existing parents just cannot do it from grid edit. Thank you againfor your help! Re: Enforce single use of a record in a relationshipThank you for the response! That makes sense but where I am struggling with that is how dohave my list of Samples without having a Parent to relate them to? Doesn't it require a Parent to create a child record? Enforce single use of a record in a relationshipI am having a bad brain lapse. The basic use case is, I have Sample Data that we combine with 4 other pieces of Sample Data to produce a Unique outcome. Each piece of Sample Data can only be used Once. In case it is confusing the best way to look at it is each sample is a limited resource with only enough of that resource to be used in one test combination. I am running myself in circles on how to set up the structure toenforce each Sample can only be used once. I was looking at doing 3 tables, SampleData, UsedSamples & CombinationResults. With UsedSamples being the join table between SampleData and CombinationResults. Was looking at Key field in SampleData is an 8 digit unique text field and a unique 8 digit Text field as the Key in the CombinationResultsField. Any simple or brilliantways for me to enforce the single use of each SampleData? Re: Chart not showing up when I email a formThank you Evan.Re: Chart not showing up when I email a formany recommendations to get charts to show when emailing?Re: Hiding report columns based on view?I have been doing that on a form by having 2 different reports and setting one to show on Add or Edit and the other to show on view. Not sure if there is another way.Chart not showing up when I email a formI have a form that I email out daily that includes several Reports in it. I have added a couple charts as well and everything looks fine on screen but when it is emailed the reports show up but the charts are blank. any ideas on how I can get charts to show up? In Quick Base In Email The "show details in new tab" where the charts should be, do nothing if you click on it Thank you in advance