2009/12/30 Andreas Saeger <[email protected]>: > Dotan Cohen wrote: >> >> In Base, how can text fields have a dropdown box showing existing data >> if a certain condition is met? >> >> At a lab I work at, we process requests from different local >> companies. The first field is for the area, and the second field is >> for the company name. I want only the companies shown that are located >> in the area selected. Is this even possible in Base? >> > > Hi Dotan, > It's me again. Without SQL, macros and circumstance I can offer a very > simplistic alternative: http://www.mediafire.com/?2ytd4znmmqd (2 list boxes > bound to the same field). >
Thanks, Andreas, it's been a hectic week and I've just gotten around to this. I do not understand what the form does. It appears to me that when I select a,b from one side, it tries to select b,a from the other. it doesn't exactly work, but as it doesn't fit what we need here I'll leave it at that. I do appreciate your attempt at helping, though. We have a list of 180 businesses from throughout the country. In the database there is a table for each business, and in that table is a field for the city. I would like the user to be able to select a city from a dropdown box and then, from another dropdown box select the business. However, I want only those businesses within the city previously selected to be shown. I am not sure if Base can actually do this, as by googling I haven't found anything. I am trying to go through the docs but I do not have the time to comb them as thoroughly as I would like and I really don't know Base very well. If there is a doc which you know to explain this, a simple link with a harsh RTFM would be very appreciated! I know that this is borderline "Dear lazyweb" but I figure that maybe those more familiar than myself with Base would know where to look. I've tried, but found nothing. Thanks. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
