Skip to main content
Solved

How to heck if other table has a certain attachment

Hello, I have two tables [Client & Files] connected and I'm wondering if there's a way to check the Files table if certain "File Type" has been uploaded for that specific Client.

For example, the Client record has a status field that can only be set to "Complete" if a "Profile Picture" has been uploaded. 

Thanks in advance!



------------------------------
frnmj
------------------------------

Best answer by MarkShnierYou

So 1 Client has many files.  Make a summary field for "ANY" of where the filker is that the [File Type] is equal to Profile Picture.

Then you can have a form rule that says when the record is saved and the status = complete, then abort the save if [Any Profile pictures] is false

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
View original
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
So 1 Client has many files.  Make a summary field for "ANY" of where the filker is that the [File Type] is equal to Profile Picture.

Then you can have a form rule that says when the record is saved and the status = complete, then abort the save if [Any Profile pictures] is false

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement