Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Quote Originally Posted by sam02 View Post
    Hi i have looked and i can construct tables, queries, forms to a basic level but its the relationships that are above me
    OK, think as to how entities are related.
    An author writes several books.


    Each book can fall into a particular category.
    Each book might have more than one author?

    Break it down until YOU know what you want out of the DB. That generally defines what you need to store.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  2. #17
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2019
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Here's a possible starter for you:
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #18
    sam02 is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2017
    Location
    UK
    Posts
    15
    Quote Originally Posted by Bob Fitz View Post
    Here's a possible starter for you:
    Hi i have just had a quick look and that looks brilliant but i have all the family coming over today so not a lot of time to look properly but on first look it look great thank you

  4. #19
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2019
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Quote Originally Posted by sam02 View Post
    Hi i have just had a quick look and that looks brilliant but i have all the family coming over today so not a lot of time to look properly but on first look it look great thank you
    Glad it is of interest to you. I'm also busy today with family, but if I can be of any further help, post back and I will respond asap

    PS
    Enjoy the rest of the festive break.
    Last edited by Bob Fitz; 12-27-2023 at 12:04 AM.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 11
    Last Post: 02-02-2019, 11:54 PM
  2. Forms collection vs. AllForms collection
    By Access_Novice in forum Programming
    Replies: 1
    Last Post: 01-03-2016, 12:30 AM
  3. DVD Collection Database
    By I R Foof in forum Access
    Replies: 7
    Last Post: 07-17-2014, 06:52 PM
  4. Building my own Collection(s)
    By Rawb in forum Programming
    Replies: 2
    Last Post: 12-14-2012, 01:01 PM
  5. Replies: 3
    Last Post: 11-16-2012, 10:15 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