I'm triyng to create a drop down that will do one of two things. The Field is named Payee. The two options in this drop down field are "Client" and "Vendor". If the Payee is Client, the process st...
Mark sorry to bother you on this. If I have three fields and first determines the drop down on the second and the second field determines the drop down on the third, do iIneed one table table to hold these drop downs or would there be three separate tables and these will be then be looked up from let us say projects table when someone is setting up a project. As an example, if category is PNP and the Dev Type is 'New', Refurbishment', extension, Dev Codes are corresponding value for New = N, Refurbishment = RR etc.
In the attached screenshotI have shown the relationship. As I have existing data in projects table, in the proposed set up would I need to re allocate new values?
Hi. Resurrecting this question... We are similarly trying to have cascading dropdown menus - many identical entries on a single form to avoid going to a record creation window each time. Is it really not possible to use a table to populate a dropdown menu without creating a connection between the elements of the dropdown and the individual records? This seems like a basic data entry scenario.
Sorry, I suggest that you post a new complete question. There is not enough detail here to answer a question.
------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com mark.shnier@gmail.com ------------------------------