Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    If you want to. I probably won't be able to look at till this weekend.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #17
    lamarse is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    10
    Okay.
    Here you have the single starting.ACCDB file (Access 2013) with the 4 tables, in english, with the ID fields, some correct other fileds in each table.
    There is the form with the TAB CONTROL which I would like to have all the 4 tables in each TAB and getting it work.

    Actually, I have no made the relationships myself 'cause I don't really understand how should work your way.

    As a remain:

    1 Client can have [One to Many] Address
    each address can have [one to many] services
    each service have [just one] invoice related.

    Thank you

  3. #18
    lamarse is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    10
    Well, from my point of view the relationship should be like this picture

    But I had to add new IDfileds diferent from the one you gave me, and well.


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

Similar Threads

  1. Relationship between tables
    By Muldoon in forum Database Design
    Replies: 5
    Last Post: 12-23-2012, 12:24 PM
  2. RelationShip between Tables
    By joe357 in forum Forms
    Replies: 3
    Last Post: 08-20-2012, 06:01 PM
  3. relationship between tables
    By jassie in forum Access
    Replies: 1
    Last Post: 03-27-2012, 05:14 PM
  4. Replies: 2
    Last Post: 02-13-2012, 02:12 PM
  5. Relationship between tables
    By kpk in forum Database Design
    Replies: 3
    Last Post: 10-14-2011, 11:49 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