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 |
#1
|
|||
|
|||
Table Structure Question ?
Is it better to use a single table and have one of the fields (for the form)
lookup via a combo a state for example or; use a query for the form and then link both tables together so that the state can be looked up this way? One table for the form or two tables using a query? Thanks, |
#2
|
|||
|
|||
To me, the answer is "it depends". What's the point of the form? Only to
show the information, or to allow people to change it? If they can change the information, using one table and a combo box would seem to make the most sense. If they can only see it, using the two tables in a query should be sufficient. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Dave Elliott" wrote in message ... Is it better to use a single table and have one of the fields (for the form) lookup via a combo a state for example or; use a query for the form and then link both tables together so that the state can be looked up this way? One table for the form or two tables using a query? Thanks, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Survey Results | SAm | Running & Setting Up Queries | 10 | May 17th, 2005 08:32 PM |
Table Desing Question | Eddie's Bakery and Cafe' | Database Design | 5 | April 11th, 2005 08:54 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |