Results 1 to 5 of 5

Beginners question

  1. #1
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    Beginners question


    I have a silly question about tables. I have a main table that all data is sent to thru a form. I created copies of that table and named them a different name. I connected relationships from the main table to all the others connecting asset I.D. My question is..... if i add data thru the form that goes to the main table will all the other tables collect the same data at the same time or do i have to creat relationships with each column in all the tables?

  2. #2
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    636
    Hi,

    might I ask why you created copies of the main table? The whole point of a database is to have the data stored in one place without any doubles or copies??????????

    regards
    NoŽlla

  3. #3
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    beginners question

    The other table are by customer. So I could creat a query from that and have just those customers show up

  4. #4
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    66
    Quote Originally Posted by nashr1928 View Post
    The other table are by customer. So I could creat a query from that and have just those customers show up
    Yes. Just create queries that pull and sort the data you want from the one table.

  5. #5
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146
    Thank you for your assistance

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

Similar Threads

  1. a beginners question
    By bluelondon in forum Access
    Replies: 0
    Last Post: 07-12-2007, 04:54 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
  •  
Tech Forums: Microsoft Office Forums