Hello,
I am working on a manufacturing db and am trying to set up relationships from a table that contains data for items being constructed. There is also, of course, a parts table. The problem I am having is the fact that I have two fields in the construction that will relate to the parts table. I can set up a relationship for each, but when I try to do a query, I get no data. What will be the correct way to set this up? The only reason it really matters is so that the customer can do his own queries - everything I'm doing with the data is being done with VB.
Thanks,
Tom
I am working on a manufacturing db and am trying to set up relationships from a table that contains data for items being constructed. There is also, of course, a parts table. The problem I am having is the fact that I have two fields in the construction that will relate to the parts table. I can set up a relationship for each, but when I try to do a query, I get no data. What will be the correct way to set this up? The only reason it really matters is so that the customer can do his own queries - everything I'm doing with the data is being done with VB.
Thanks,
Tom
