What I want to do is enter the values x, y & z on the fo

[divingbrit]

What I want to do is enter the values x, y & z on the fo
In Access I have two tables, one has 3 fields, x, y & z. These fields will contain values that I will enter via a form. The second table also has x, y and z, but also has another field called c. What I want to do is enter the values x, y & z on the form and then get the value for c returned. I have tried all ways without success. If I put a single relationship between the tables and just have one variable field, eg x and in the other table have x and c, I can write a query that will return the value of c. However when it starts getting a little more complicated then I get no return value.

Does this make sense, it was posted on our local computer help forum and has us stumped


(and yes I did post this in the wrong palce, hopefully this is better, sorry)

 

[Tanis]

First question is, why are you storing the same data in two tables? Is there a relationship between c and x,y,or z? Second question is what exactly are ypu trying to achieve?