Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old Today, 01:10 AM   #16
jjatwork
Newly Registered User
 
Join Date: May 2019
Posts: 15
Thanks: 28
Thanked 0 Times in 0 Posts
jjatwork is on a distinguished road
Re: Normalization - Qs about junction tables and booleans.

Sorry about the delay. Been off for the holiday.

@ Doc. Thanks again for the explanation. I've been doing some reading on architecture fundamentals, but there's a lot to take in all at once.


@ Dave. Yes, in theory a flag in the table would do the trick. The problem is, that I've been asked to make two different systems, one that keeps detailed track of parts used etc. and another, where the information is just typed into a string. But I'll try to rethink the design with that in mind.

The colors can be approximate, yes. They are not used for sorting, selecting or anything besides visual identification of the bike.

jjatwork is offline   Reply With Quote
Old Today, 04:02 AM   #17
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,602
Thanks: 55
Thanked 985 Times in 953 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Normalization - Qs about junction tables and booleans.

Quote:
@ Dave. Yes, in theory a flag in the table would do the trick. The problem is, that I've been asked to make two different systems, one that keeps detailed track of parts used etc. and another, where the information is just typed into a string. But I'll try to rethink the design with that in mind.

I would do this by having a memo notes field in the work order.

you end up with this

workorder table (include a Work Notes field)
workorder parts used table

enter some work notes on each job.
if need be, have a subform to select linked parts.

the job could just be a service, with no parts
if you need to replace a tyre, and brake parts etc, you can add the parts used.

You want to try to design the system to deal with all eventualities in a single streamlined system, It will be much easier than having multiple systems.

The colour is a red herring (sorry). You can either have a lookup table, or just free text. It only matters if you want to do a breakdown of bikes by colour - in which case you need a look up table, as otherwise you will get entry discrepancies and misspellings such as "red, red, read, pink, dark red, red multi" etc. If you have a lookup table, of course, you limit the colours to specific values.

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms that update/create records in multiple tables, including junction tables excal Forms 5 07-11-2011 08:46 PM
Junction Tables lmg0115 Tables 1 08-20-2008 06:48 AM
Normalization: One-to-many out of a junction table without a primary key rbrady Tables 8 04-08-2008 01:16 PM
Junction Tables patkeaveney Tables 6 10-13-2005 06:54 PM
Junction Tables munday63 Tables 1 03-02-2005 08:40 AM




All times are GMT -8. The time now is 04:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World