Table for activities
I have an excel spreadsheet with name of company and then up to 75 activities from one particular company, then it's price My task is when the user uses a pull down menu to pick the activity the oth...
Forum Discussion
I think what you're looking for is this:
How to add Cascading Dropdowns
Based on your sample spreadsheet, what you would want to do is have multiple tables: e.g., one table for vendor, and one table for activity, and maybe cost is part of the same record as activity. Then you create a relationship each vendor has many activities (parent -> child).
Next on your form you add all the related fields and visit the field settings. For the "Related whatever" fields and selec the "this depends on a previous selection" option. For example, activity depends on the vendor selection. This will make it so to select an activity, you must first select a vendor, and the activities will be filtered to the vendor selected. And any extra data like price will autopopulate if it's on the same record.
- MarkShnier__You
Qrew Legend
If we make the assumption that you're trying to do is fill out a form for a booking for a particular client and you want to pull down the current price then you're going to do a look up down into that booking record. In fact, the booking record probably has something like one booking has many booking activities.
But what I wanted to point out is the use of what is called the snapshot field. You will want to look up the current price of the activity and it's my practice is to suffix that look up field with the phrase (lookup). Then you create a new field of the same type of field as the lookout field, in this case numeric currency, and then at the bottom of the field properties, you set that to be a snapshot field based on that look up field. That way you freeze the price at the time of the booking and as the prices may change in the future, you don't want your historical record suddenly reprising themselves.
Please feel free to post back if you have any more questions about the relationships in your app or the use of snapshot fields.
