Skip to main content
Question

Conditional Drop down

  • September 19, 2024
  • 0 replies
  • 127 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+15
  • Registered
  • September 19, 2024

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