Results 1 to 3 of 3
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post I need help to relationship in Table

    I'm sorry If I have faults in writing , Because My English isn't perfect

    I have some invoices in Table : 1- Sales invoice , 2- buy invoice , 3- Returns by customers , 4- Returns to the producing companies , 5- damage
    I made these 5 Tables for head of invoice ,,, and also I made 5 sub Tables for these 5 head invoices
    and also I have these tables : Goods name , costumers name , Productions name , expenses ....
    How I will make relationship between them ? ,,, and When I make A computational operations in Query for these Subform , I should use these Queries for reports , I can use it for Forms ,,, When I bring them to Forms it says me , you can't enter any data ,,
    for Example : in subform I have ( Number , Goods name , Quantity and Price ) When I make Total for it , It's okay
    But I can't use it for Forms .
    and When make Relationship for these five Tables , Even show me Store , It's tells me , you should Movements to all bills even show you Store , ( for example : I bought something from one Production company and When I enter those data in buy invoice it isn't appear in Store , I should enter those data in these 5 invoices even it;s gives me right store )
    and I have a problem with costumers ,,, When I enter costumer's name in invoices , His Mobile and Address isn't appears .
    If anyone can help me , I will be very glad .

  2. #2
    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
    Here are some links to database concepts. I suggest you review them.

    Videos for Database concepts

    Intro to database
    The relational model
    Basics of data modelling

    Tutorials to work through.
    Spend 30-45 minutes working through one of these tutorials from RogersAccessLibrary. They show the Problem, the Process and include solutions. You can use this technique with any database.

    You have to work through the exercise to appreciate the process and result.

    Class information

    Consolidated Widgets


    Good luck.
    Last edited by orange; 10-05-2016 at 06:00 AM.

  3. #3
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    Thank you so much for your help , I will try to watching them

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

Similar Threads

  1. GUI and Table Relationship help
    By karekarex in forum Access
    Replies: 1
    Last Post: 06-11-2013, 09:09 PM
  2. Which table should have this relationship?
    By MickFlanagen in forum Database Design
    Replies: 14
    Last Post: 05-16-2013, 02:18 PM
  3. Table Relationship Help
    By JoshLewis in forum Database Design
    Replies: 1
    Last Post: 04-08-2013, 10:55 AM
  4. Replies: 2
    Last Post: 04-08-2012, 03:04 PM
  5. Relationship Table Help
    By Nick F in forum Database Design
    Replies: 5
    Last Post: 10-10-2011, 01:28 PM

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