+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
Office Software Thread, MS Access 07 - Relationships problem in Technical; I can understand what you mean there but a one to many relationship is as my example in database terms. ...
  1. #16
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,350
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    I can understand what you mean there but a one to many relationship is as my example in database terms. Adding the one to many in the relationships box helps preserve things like referential integrity etc

    The compatability tables only needs to hold consumable IDs and printer IDs so just 2 data fields.

    The printer table could hold the location table as well as you cant have one physical printer in more than one location.

  2. #17
    edd
    edd is offline

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We have more than one model of the same printer onsite and so it can be in many locations.

  3. #18
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,350
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    Quote Originally Posted by edd View Post
    We have more than one model of the same printer onsite and so it can be in many locations.
    If then you did the printer key by serial number then add a single location field to that. It would make making queries and reports so much easier in the long run.

  4. #19

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    247
    Thank Post
    23
    Thanked 37 Times in 28 Posts
    Rep Power
    20
    I'd still be inclined to have the compatibility records as

    printer1 cart1
    printer1 cart2
    printer2 cart1
    printer3 cart4
    printer3 cart1
    printer3 cart3

    rather than lumping all the values into one field (and having separate printertype and printerinstance type tables as Jamo has).

    Otherwise I think you'll find you're looking for a way to select just one item from a comma-separated list of cartridge types! Also, to be honest, it'll work a lot better with the allocation side of things.

    Just how I'd do it anyway!

    Matt

  5. #20

    Join Date
    Dec 2005
    Location
    Midlands
    Posts
    130
    Thank Post
    2
    Thanked 12 Times in 12 Posts
    Rep Power
    20
    then you will need a printer_type table between printer and printer_consumable with another one-many.

    the printer will store the name and location of the printer

    the printer type will store which carts are compatible

    A printer can only be of one type and a printer type applies to many printers.

    Dean

  6. #21
    edd
    edd is offline

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The information being held in the Locations Table will now be stored in the Printers Table. Also the Consumables Tables will now have one consumable to the printer, like Jamo and Matt has mentioned above, as I got the combo box to only show the compatiable cartridges to the selected printers.

    Thanks guys for your help.
    Edd

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Relationships with local schools
    By FreeWill in forum General Chat
    Replies: 21
    Last Post: 20th May 2008, 02:33 PM
  2. Trust Relationships and DeepFreeze
    By AdamWilden in forum How do you do....it?
    Replies: 6
    Last Post: 4th February 2008, 11:16 AM
  3. Sales: building up relationships
    By contink in forum General Chat
    Replies: 8
    Last Post: 30th January 2008, 10:17 AM
  4. My Docs access problem
    By Ste_Harve in forum Windows
    Replies: 2
    Last Post: 30th August 2007, 12:32 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •