bleonard

micromd Try a 2nd TO, see attached file Brian Lookup2.zip

Hi to All, I have looked at your solutions to this post because I have a similar situation, but I cannot grasp the methodology in the examples. What I want is to have a value list in field-"Maker" and when a Maker selection is made it will autofill another field with a value list of that maker's products. My Maker value list would have about 8 or 9 values. I can't quite figure out what the 2 extra fields in your example are for since they both have the same calc and can't figure whyb there needs to be a Form View2? I would appreciate your help to understand this better. Thanks heaps, Brian

Inky Phil, Thankyou very much for your reply. At last I can see some sense here. Genx, Thankyou very much indeed, your way is even easier and I have the bonus of actually now knowing how to use a variable as well! Nice to also have help from a fellow Aussie. Thanks guys!

Is there someone out there who could please give me a sample file {preferably a very simple one} showing exactly how to use the SetField function? What I would like is if say I have a Jobs table and want to copy the job number to a Contractor table without doing a copy/paste or copy other info from one table to another without copy/paste or using a portal. Are there any brave takers please? I have looked at several previous posts here and elsewhere and haven't understood the principle from any of them. I don't understand the use of variables either!! Thanks in advance to any contributors.