Did I lose you there?
Did I lose you there?
Ok here it is. Some of its a bit of a mess, because as you said its a test db.
http://www.2shared.com/file/DI5lWWdm/it_pat.html
This site will let you post attachments so you do not need to use those type of file hosting sites loaded with cookies and pop ups. Use the Post Reply button or Go Advanced and scroll down to Manage Attachments. I would zip it up first.
Ok, I posted here.
I modified the Table2 form and load it when the db runs. Try it.
Ok Thanks it seems to be working now, just that Cartesian product problem now. What exactly did you change to make it work? I noticed the LookupPrice field instead of price as you said it would conflict.
That is *all* I changed in the query.
Oh thanks! I can't believe the problem was so simple.
Are you satisfied enough to mark this thread as Solved?
Yes as far as this problem goes its solved thanks
Any time. I like the easy ones.
HOORAY! Congrats All! Sorry, I had to.