Here in the US, it's a holiday so a lot of folks aren't spending much time here. Neither am I, but I happen to have a few minutes...
There are two ways to do what you describe. Both methods have their merits. You'll need to decide for yourself which method works best for you. You should also not use a drop down list based on the customer's name for this, what if you get two customers with the same name? What if a customer changes their name? Use an ID serial number generated in the customer table and you can select a customer by name but link a work order record to that customer by number.
See this thread for a description of both methods and how they are different: Auto Fill
Hey - thanks Phil. I will take a look. Forgot it was a holiday in US.
Thanks again for taking the time to respond!!!
This file also shows this technique:
I'm busy helping someone else now but if you can't figure it out let me know and I'll make you a more detailed explanation.
Ok- Thanks to both of you this is working great. The only issue I have, that may not be avoidable, is I would like the user to begin typing in the name and have relevent stored customers come up in the drop down list. Maybe two customers have same name, but different address and the user can select the appropiate one. I noticed that "Auto-complete using value list" is greyed out and not selectable under this setup. Is there a way around this or should I head in another direction.
Have you tried just typing ahead in the dropdown list? Because normally you can do that.
Try it out in my file (TwoTablesLinked)
Click on the yellow dropdown and start typing one of the names that's in there.
Also if you immediatly want to show the adress in the dropdown you can mace a calculation field like I did in my example file (the c_FullName field) and set that as the second field in the valuelist settings.
But that might make it a little long.
I tried typing the name into your sheet and nothing happens. I still have to click to activate the dropdown. The name does not autocomplete at all. If you have a look at yours you will see it too has the "Auto-complete usind existing values" greyed out under the "control style" menu in the inspector.
Don't know if there is a way around this...
I still have to click to activate the dropdown.
Of course, you can't just start typing without first selecing a field. The steps are:
You open your dropdown. Then you'll see a long list. If you don't want to start searching manually you just type the first letter of the name, and the second letter, ...
The dropdown will select for you the first person with the name starting with the letters you are typing in. If that's the person you are looking for you enter or click that name and you save this change by clicking enter again, hitting the tab key and voila, that person is selected.
If you have a look at yours you will see it too has the "Auto-complete usind existing values" greyed out
I know that option is greyed out, but that option has nothing to do with the auto complete within the dropdown.
I just tried (again) in my own file and it's working very nicely. The thing to look out for is "Include arrow to show and hide list"
If you have that checked your dropdown doesn't show up immediatly.
In my example you will see it does.