Conditional Drop Down Set Up
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...
Forum Discussion
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?
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?
OK no pobs.