Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-12-2019, 11:40 AM   #16
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,982
Thanks: 13
Thanked 1,538 Times in 1,463 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Best way to design table for (gender & province)

OK, now that we've determined that ProvinceID doesn't have anything to do with Province
Please try to add
Province = BC
Employees = 3
Gender = M

Clearly my description was confusing but it doesn't make sense to have two instances for Province = BC and Gender = M which is why I said that if the PK isn't compound, a unique index on Province + Gender is required to enforce the business rules.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-12-2019, 12:04 PM   #17
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,104
Thanks: 110
Thanked 2,746 Times in 2,505 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Best way to design table for (gender & province)

Mark
That's even worse...
I'm going to try NOT to click on any more links you provide on this topic.

Pat
I've no disagreement with that point about indexing. Obviously you don't want 'duplicate records' in any table

Calvinie
Are you still there or has this veered into realms you don't want to get involved with?

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   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
[SOLVED] Gender Neutral? Uncle Gizmo The Watercooler 6 08-08-2019 03:13 PM
Count by age range AND gender ncub Reports 1 07-08-2015 11:21 PM
Shall i create another table for gender in payrolls database? Harrold General 1 11-01-2011 07:15 AM
Matching title and gender 1961templar Tables 113 11-27-2009 10:09 AM
Countries,state/province,region patrickd123 General 1 03-03-2007 07:46 PM




All times are GMT -8. The time now is 07:40 PM.


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