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
|
|||
|
|||
New linked table or not
Trying to discern better design.
tblDoc DocNum Text Title Text Aircraft A (yes/no) Aircraft B (yes/no) Aircraft C (yes/no) ...Aircraft Z (yes/no) OR tblDoc DocNum (text) Title (text) tblDocAircraft xOverID (Autonumber) DocNum (text) Aircraft Type (text) My struggle with the second option (which I think might be a better design) is that I want to be able to show the aircraft type in each doc using checkmarks to make the report/form more visual. Is this possible with the second option? I also want to pull a report of docs by aircraft type. any input is appreciated. -- Teach me to fish! Thanks for the help. Pax, M |
#2
|
|||
|
|||
New linked table or not
Never design a database schema based on what you want on a report. The
second design is the correct way to do it. The first design will create more problems than it will solve. If you can provide some more detail on how you want to present the report and what is the rule that decides which aircraft are shown on a document and which should have check marks, perhaps we can provide some assistance with that. -- Dave Hargis, Microsoft Access MVP "m stroup" wrote: Trying to discern better design. tblDoc DocNum Text Title Text Aircraft A (yes/no) Aircraft B (yes/no) Aircraft C (yes/no) ...Aircraft Z (yes/no) OR tblDoc DocNum (text) Title (text) tblDocAircraft xOverID (Autonumber) DocNum (text) Aircraft Type (text) My struggle with the second option (which I think might be a better design) is that I want to be able to show the aircraft type in each doc using checkmarks to make the report/form more visual. Is this possible with the second option? I also want to pull a report of docs by aircraft type. any input is appreciated. -- Teach me to fish! Thanks for the help. Pax, M |
#3
|
|||
|
|||
New linked table or not
i would say that you need three tables since, presumably,
an Aircraft Type can be related to more than one Doc; tblDoc DocNum (text) Title (text) tblAircraft AircraftID (Autonumber) AircraftType (text) tblDocAircraft xOverID (Autonumber) DocNum (text) AircraftID (number) -- _________ Sean Bailey "m stroup" wrote: Trying to discern better design. tblDoc DocNum Text Title Text Aircraft A (yes/no) Aircraft B (yes/no) Aircraft C (yes/no) ...Aircraft Z (yes/no) OR tblDoc DocNum (text) Title (text) tblDocAircraft xOverID (Autonumber) DocNum (text) Aircraft Type (text) My struggle with the second option (which I think might be a better design) is that I want to be able to show the aircraft type in each doc using checkmarks to make the report/form more visual. Is this possible with the second option? I also want to pull a report of docs by aircraft type. any input is appreciated. -- Teach me to fish! Thanks for the help. Pax, M |
Thread Tools | |
Display Modes | |
|
|