Still designing, need help with Many-to-Many

"Nikos Yannacopoulos"
Let me see if I understand this correctly:

Am I guessing correct so far?

So far so good. :-)


The question is how to identify the chosen vendor's
part number for the given part (to communicate that to the vendor), right?
Well, it takes no more than a
simple DLookup on table tblVItem!

Again, I think you are on the same page as I.

Thank you for the answer. I kind of thought this after looking hard at the
diagram. Everything I saw in front of me showed that I would use tblVitem,
but being new, I wanted to make sure I was correct. As I near the
completion of the table design, I get a bit worried that I covered
everything while allowing easy alterations and upgrades for the future.
This usually entails over-analyzing what is staring right at you clear as
day! :-)


Tim

Tim,

This is actually concerning your newer post in this NG, but I didn't
want to "burn" it by replying there (by "burn" I mean that some will
often skip posts thathave already been replied)... that's because i
don't have a real answer to it, I just wanted to alert you to the fact
that your Excel conversion to .html didn't work very well, so the web
page isn't really usable.

Regards,
Nikos

Parts Manager wrote:
"Nikos Yannacopoulos"

Let me see if I understand this correctly:

Am I guessing correct so far?


So far so good. :-)



The question is how to identify the chosen vendor's
part number for the given part (to communicate that to the vendor), right?
Well, it takes no more than a
simple DLookup on table tblVItem!


Again, I think you are on the same page as I.

Thank you for the answer. I kind of thought this after looking hard at the
diagram. Everything I saw in front of me showed that I would use tblVitem,
but being new, I wanted to make sure I was correct. As I near the
completion of the table design, I get a bit worried that I covered
everything while allowing easy alterations and upgrades for the future.
This usually entails over-analyzing what is staring right at you clear as
day! :-)


Tim

Tim,

I checked the hyperling again and it came up OK the second time, so
false alarm.

Nikos

Nikos Yannacopoulos wrote:
Tim,

This is actually concerning your newer post in this NG, but I didn't
want to "burn" it by replying there (by "burn" I mean that some will
often skip posts thathave already been replied)... that's because i
don't have a real answer to it, I just wanted to alert you to the fact
that your Excel conversion to .html didn't work very well, so the web
page isn't really usable.

Regards,
Nikos