If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Advice on basic tables and relationships | ITMA | General Discussion | 1 | April 23rd, 2005 12:32 AM |
Multiple tables - Multiple forms (Access 2000) | Alastair | Using Forms | 0 | November 12th, 2004 03:30 PM |
Starting over with appending data from one flat table to multiple relational tables. | Stranger | Running & Setting Up Queries | 1 | August 5th, 2004 04:32 AM |
Multiple tables on to one form | LMB | New Users | 4 | May 23rd, 2004 03:35 AM |