Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    http://allenbrowne.com/AppIssueBadWord.html


    http://www.access-programmers.co.uk/...d.php?t=225837
    Good luck with your project.

  2. #17
    Stephenson is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Location
    North West
    Posts
    110
    Thank you Micron I appreciate all your help.

  3. #18
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Stephenson,

    Do you have samples of your class, type and model? Just to give readers a clear picture.

    Do you have a data model that you can test against your requirements with some sample test data?
    Here's a technique we used to use during design refinement.

  4. #19
    Stephenson is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Location
    North West
    Posts
    110
    Hello Orange.

    I put some examples onto an Excel worksheet to display the equipment hierarchy I'm looking for. I'm going to put some forms and queries together and see how everything works. Sort of test the model as you've suggested.


    Click image for larger version. 

Name:	2016-11-08 12_26_46-Example - Excel.png 
Views:	11 
Size:	48.2 KB 
ID:	26355

    Thank you for having a look and providing the helpful link,

    John

  5. #20
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @Micron,
    ssanfu, you have way too much time on your hands!
    Do you actually use Access to create a bunch of tables, then create the relationships? That would seem to take a long time (and I can type). Or are you using some sort of db relationship building software to speed things up?
    It took around 15 minutes to create the tables in Access. I'm poor - don't have any fancy store bought relationship building software.

    And I was just demonstrating how the tables are arranged can make a difference on how you think about the data/tables/flow.
    I didn't try to make suggestions on the fields because I think (I know) you are much more qualified in this area. (just stating a fact - and I agree with you about the tables)
    The table layout in the relationship window along with the "_PK" / "_FK" suffixes makes it easier for me to design tables/queries/forms/reports.

    And, yes, being retired allows me (us?) a certain amount freedom with my (our) time..??

  6. #21
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Yes, retired too. But I think you suffer from a common retiree syndrome - time flies when you're having fun. 15 minutes for that? You either had a whole lot of fun, or you're a big fibber Or someone set your clock back when you weren't looking.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #22
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Clock??? Clock??? What is that??

    I did a lot of copying and pasting. (and I am home alone - sometimes bored out of my skull...)

    So, yeah, I had a whole lot of fun!!!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Electrical Hierarchy
    By HelpDesk in forum Access
    Replies: 55
    Last Post: 06-26-2015, 06:51 AM
  2. Creating Hierarchy
    By Just_Some_Guy in forum Access
    Replies: 17
    Last Post: 07-24-2013, 07:06 AM
  3. Using a hierarchy table
    By younggunnaz69 in forum Queries
    Replies: 3
    Last Post: 07-18-2012, 10:11 PM
  4. Hierarchy summing
    By dskysmine in forum Queries
    Replies: 17
    Last Post: 06-19-2012, 04:08 AM
  5. product hierarchy
    By Lata in forum Access
    Replies: 13
    Last Post: 08-03-2011, 02:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums