Page 6 of 6 FirstFirst 123456
Results 76 to 78 of 78
  1. #76
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Hi Steve,

    thanks for the response im trying to find my way around access and think i need to learn more.

    couple of things

    how to do i fix the misdirection I set up?

    if you had time could you do what you suggested and zip it back up

    like i offered previously i think seeing it done and figuring it out would help me learn faster - id be happy to donate via paypal for the time spent

  2. #77
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Hi - I think i fixed gthe relationship using the source button and the builder- just dont really understand what you mean about the juntion table. still like a guru to llok at it!

  3. #78
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    I suggest you give a brief description of the requirement based on your "re-engineered" approach. As I often advise -don't jump too quickly into physical Access/database. It seems there is a lot less detail involved than what you mentioned early on. I saw references to Product and Order earlier, but don't see that in your tables.

    You need a plan with some sample required outputs. Make sure you have the data necessary for those outputs/questions. Some test data and test scenarios will allow you to "test" your proposed set up while still resident on paper. Once your model satisfies your requirement, you can use that as a blueprint for your database.

    Do your analysis and design before getting too focused on physical Access. As one colleague suggests "if you can't do it on paper, you can't do it with Access".

    Good luck with your project.

Page 6 of 6 FirstFirst 123456
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-19-2017, 11:07 PM
  2. Need help not sure what to call it :-(
    By jscalem in forum Database Design
    Replies: 8
    Last Post: 08-30-2017, 12:45 PM
  3. What do you call this?
    By mrmims in forum Access
    Replies: 4
    Last Post: 11-11-2015, 12:43 PM
  4. Call and phone
    By drunkenneo in forum Programming
    Replies: 0
    Last Post: 08-28-2013, 12:49 AM
  5. Not even sure what to call this one
    By eizquierdo in forum Queries
    Replies: 2
    Last Post: 03-14-2013, 12:08 PM

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 - Senior Forums