Results 1 to 3 of 3
  1. #1
    rgrwatson85 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011

    Question Quick Question about Subform

    This is my first post so if I say something out of the ordinary or you need more info please forgive me.

    I am creating a database for a small company. This is actually a school project, but we had to find a real world business that could benefit from a simple database and I am build a CRM database, using Access 2010, to track customer orders and the such. That is a little background so on to the actual question...

    I am wondering how I should go about creating the orders subform on my customer order form. Is it wrong to just drag the table with all the information i need in the subform, or should I create a form from that table and then use that? It seems like it would be redundant to create an actual form to use as a subform as opposed to just dragging the table over.

    Hopefully this hasn't been to confusing. I'm brand new to this and want to do a good job and get a good grade, but I also don't want to handover a garbage database to a company since they are saying they want to pay me for it.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    I am not a fan of using the datasheet view for subforms, I always design my own, but really, it depends on what your customer wants. If they are happy with a datasheet view there is nothing wrong with creating your subform that way. Just make sure to follow normalization rules

    you should have a customer table, an order table and an order detail table and likely an items or services table possibly with costs that you can inherit but change if need be.

  3. #3
    rgrwatson85 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Thanks so much for the reply. I like the data sheet view because it allows me to see each item that was assigned to the order as opposed to having to go through a different form to see the different items. Again thanks for the response, and I'm sure you will be hearing lots of questions from me in the future.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Quick coding-orginization question
    By Ashe in forum Forms
    Replies: 2
    Last Post: 09-16-2011, 09:35 AM
  2. Quick SQL Query question.
    By Suoipoc in forum Access
    Replies: 4
    Last Post: 09-06-2011, 09:10 PM
  3. Quick question for all of those who use Access
    By claytonkeirns in forum Access
    Replies: 1
    Last Post: 09-06-2011, 04:04 PM
  4. Quick Module Question: :)
    By oregoncrete in forum Modules
    Replies: 11
    Last Post: 04-04-2011, 04:42 PM
  5. Quick Question
    By Imgsolutions in forum Access
    Replies: 3
    Last Post: 07-19-2010, 11:22 AM

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