Search results

Hi Tim and Rabbie. I am suffering a bit from the terminology, I am trying to explain that I have done what you suggested, but access is not my first language:o Tim, you are correct, what I did first was put a combobox on a subform. The subform is bound to the parent form (main form) with a...

Thanks Tim, I am sorry I did not post a very detailed message but you have answered my question. The record source for the subform is a query. I have the combo box and its value is from a query with a value I want to narrow the subform values with. I changed the criteria of my subform query to...

Can I use an unbound combo box on a form to narrow the records appearing on a subform in the form? If I do this, does the subform have to have the field of interest, or can the combobox refer to the many side of a foreign key? Any help would be appreciated.

Thanks for pointing me in the right direction. It's funny how you become used to doing things even if it is not the right way. You learn something new every day!

Hi Rabbie and Neileg. Thanks for the help. I have another question. "Table-level lookup"? If you don't mind explaining what you mean. I have always used them. What is the alternative? Also, what naming convention should I have adopted? Do you have a link to help me learn the lingo?

Hi Rabbie and Peter F, I am definitely not good with SQL. Could you please explain how Peter F's Query1 and Query2 works? I can see that they work but I can't quite grasp why... Also Rabbie, I am not sure why you said: "The relationships linking Table 1 with Table 3 and Table 2 with Table 3 are...

Hi Rabbie, the two tables 1 and 2 each have a one to many with table 3 but are unrelated to one another. The fields in table 3 each lookup to table 1 and 2 and combined are a unique key in table3, you just have to find the unused combination. If I create a query of the fields from table 1 and 2...

Hi Rabbie, I hope this works.

I have thought about this for days now (and nights) and I have simplified my problem below. (I even bought a book) I have three tables: 1, 2 and 3. Table 1 = a, b and c Table 2 = x, y and z Table 3 combines table 1 and table 2; ax, ay, az, bx, by, bz, etc. Table 1 and Table 2 are both One to...