I am new to this group, and an admitted novice in the workings of Access. I am running Access 2010 on a Windows 8 64 bit OS. I am using Access 2010 Inside Out as a reference, and I have written some very small and simple programs in Access 2000.
I am attempting to write a simple(?) program to generate a switchlist with which to operate my model railroad layout. I have made up several tables (Location, Industries, Freight Cars, and Commodities). I will have several Industry tables, one for each train assigned to that series of Locations. One of the challenges I have is that one industry could have two tracks, i.e. an inbound track for empties and an outbound track for loads, so an industry could be duplicated 2 or 3 times in a table, but have a unique spot number. In addition, an industry could have one track with up to five doors on which a specific freight car could be spotted. The end result would be a switchlist that tells the conductor of the North Local, for example, which industries at which locations receive which freight car at which spot number, and whether the car is an empty or a load, and the commodity being shipped or recieved. In addition, I would like the program to remember which cars were spotted during the previous session, and a certain percentage will be available for pick up at the next session. I know the tables will need to be linked, and relationships established. Currently the Industry tables has the following fields: IndustryID, IndustryName, SpotNumber (always unique), and what the spot is (Door, Dock, Spout, etc.)). I don't expect anyone to write the program, but any help in putting together the Industry tables would be most appreciated.
Thanks for reading all of this,
Bob Burke
Posted by: bburke@swiftaz.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar