We allocate time-based on Customer and Project. When I set up these two fields in TimeCard I would like the Customer dropdown to drive the Project dropdown, so that only Projects relating to that Customer show up. Can this be done?
It cannot be done in exactly the way you describe, but I have another suggestion which I think would work better:
Since I presume all of your projects have a customer (or are internal) can use only one dropdown for your end-users. Instead of having one dropdown for Project and one for Customer, why don’t you simply have one dropdown for Project and then use the Customer as a Tag Type?
You will still get all of the data collected correctly and your end users will only have one dropdown to fill out for every appointment. Thus you minimize the amount of work every employee have to do, which makes for better data and lower costs.