Skip to main content
Question

Conditional Drop down

  • Sep 19, 2024 5:11 AM UTC
  • 0 replies
  • 139 views

Forum|alt.badge.img

Hi, 

I have 

Tables and Fields:
Employee Table:

Fields: EmployeeID, EmployeeName, PhoneNo, LDAP, JoiningDate, Level


Project Table:

Fields: ProjectID, ProjectName, JoiningDate, ClientID
Client Table:

Fields: ClientID, ClientName
Emp-Proj Table (Join Table between Employee and Project):

Fields: RecordID, ProjectID, EmployeeID, ClientID, EmployeeName, ProjectID-ProjectName

I want to implement form rule 

    • Set a rule like: β€œWhen EmployeeID is selected, show only projects from the Emp-Proj Table where EmployeeID matches the selected employee.”
  • This will filter the projects based on the employee selection.
  • I am unable to implement above rule after relationship establishment to  tables . 
  • Please help or share screenshot to implement When EmployeeID is selected, show only projects from the Emp-Proj Table where EmployeeID matches the selected employee.”

Thanks

Bharat 

 

This topic has been closed for replies.

Forum|alt.badge.img+19
  • Qrew Champion
  • Sep 19, 2024 2:37 PM UTC

Here is an older post that describes setting up a Conditional Drop Down

 

https://community.quickbase.com/discussions/quickbase-discussions/conditional-drop-down-help/60814