multiple relationships between 2 tables

Blenvid wrote:

Hi Tim,

Please note from my original message:

"My question is that I would also like to link my serverService2 and
serverService3 fields above to the same third table. This way, if I make any
changes to any of the server services in the third table, it also shows up in
the 3 fields on my 2nd table.

Is this even possible? Please advise."

Your suggestion Tim, "It's a no-brainer that this is a Design Problem. These
fields should be three rows in a single table," was already suggested in the
beginning. I was hoping for other possible solutions. Others had started
putting possible solutions up.

Why were you hoping for other solutions? Of course, there probably are
many different ways to organize your information, but some might involve
WAY more work than others, work that is likely to accomplish no useful
purpose. (You could use the time saved to go golfing or something.)
Some of the unnecessary work that you can avoid happens later on, when
you have to correct some mistake or to re-enter data that should already
have been in your Tables, stuff like that.

Alas, I have gone ahead re-entered my data with the three fields from before
comprised into three seperate entries, three rows. It took me hours to do it
with all the data I have, but I guess that's what happens when your design is
wrong.

What did you do that took "hours to do it"? In an earlier message, I
suggested a method of conflating those 3 fields that took me maybe 2
minutes, and without defining any new Queries. Oh, well, now that
you've done it, there's no need to do it again, but it does leave me
wondering exactly what you did!


Thanks for your time everyone who contributed.

-Blenvid

Maybe you're happy with what you have now (I hope so), but if you would
like to post here what you have designed, maybe with a record or two of
(sanitized -- no actual bank account numbers, &c.) sample data, I'm sure
people here would be happy to look at that and either make suggestions
or say "Looks OK to me"...

-- Vincent Johns
Please feel free to quote anything I say here.