reports linked in other forms

Question

We have a report that shows a summary of all reported problems within the last 90 days for each of our locations. I have that report linked to our Service Request form so that we can see if the issue is reoccurring or not. I have the report only displaying the affected equipment in question. However, I would also like this to only show the location in question, instead of all of them. 
------------------------------Katlyn Allen------------------------------

MarkShnierYou · Answer

np,just make a concatenated field on the Service Request table in the format Store - Issuefor exampleList("-", [Store], [Issue])Then make that same formula field on the IT Previous Problems table Then configure the Report Link field on the Service Request form to match up those two fields.  Note that the report will only populate once the Service Request form is saved.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community