Re: [MS_AccessPros] Re: Switchlist program

 

Bob-

As I think about it some more, you might have spots that are not assigned to an industry yet.  If that's the case, then it does make sense to have a separate Spots table.

Locations:

LocationID, LocationDescription, etc.

Spots:

Spot Number, SpotDescription, LocationID

Industries:

IndustryID, IndustryName, etc.

IndustrySpots:

Spot Number, IndustryID

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Aug 24, 2014, at 7:24 PM, bburke@swiftaz.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John -

I separated Spots and Spot Numbers due to the fact that any unique Spot Number  could be any Spot; for example, in the Location Moody we have three Industries - Moody Farms, Vandiver Grain, and another Moody Farms. The Spot Number for (1st) Moody Farms is 092101 (the 1st two digits are the location, 2nd two are the specific track, 3rd two is the specific Spot). In this case, the last two digits (01) is a Spout.  The 2nd Moody Farm Products Spot Number is 092201 - the Spot is a door.  Vandiver Grain is 092101 - the spot is a spout.

The 1st two digits in Moody is always 09.  It could be (and is) that there might be two spots on the same track,

like 092202 and 092203.  Same track, different Spots.

Let me study your suggestions and go more through your book and see how I can figure this out.  Excited to put this together.

Thanks,

Bob

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• New Members 1
• New Links 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___