Results 1 to 5 of 5
  1. #1
    ajs112 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2014
    Posts
    14

    Design Ideas

    Hi all,

    I was curious if anyone might have a few design suggestions. I've hit a wall in how I'd like my database to look and how it should be represented in forms and am turning to everyone for ideas!

    The set-up:

    My database keeps track of an inventory within a state. I have a tblSurplus to track all of the inventory we have handled and a query qryCurrentInventory to display all of the inventory we still have on hand, and a form based on this query to display that information. Additionally there is a table, tblDisposals, to track what current inventory has been logged as disposed of either as a sale or as a transfer. This distinction is important because if its transferred I need to track what customer it was transferred from and to whom it went. Simple enough!

    The Goal:

    I would like to be able to select a record within the current inventory query and be able to list it in the tblDisposals as either sold or transferred. If it's transferred I need it to display where it came from and where it went. (I already where it came from in the tblSurplus). As I'm a complete novice avoidance of code (if possible) would be greatly appreciated!



    I seem to have hit a creative block and am getting burned out as I have had to teach myself form scratch this last month so any help would be greatly appreciated!

    Thanks all!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Have you looked at the Access Asset Management database template?
    http://office.microsoft.com/en-us/te...001225342.aspx

    I don't know if it has component for surplus/disposal.

    Avoidance of code means selecting asset from combobox list.

    However, simplest approach might be not to have separate tables for disposal and surplus. Assuming an asset can be acquired only once and disposed of only once, these could be fields in the Assets table. Sure, a lot of blank cells but it is a balancing act between data normalization and ease of data entry/output.
    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.

  3. #3
    ajs112 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2014
    Posts
    14
    Thanks for the suggestion June! I've taken a peak prior to starting and nothing quite meets the needs I have for this particular database!

  4. #4
    ajs112 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2014
    Posts
    14
    Any other ideas from the experienced user base here?

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Would have to see the dB, but what about a main form/sub form arrangement?
    The main form could have the current inventory and the subform would be the disposal of the equipment (sold/transferred)

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

Similar Threads

  1. Need Ideas..
    By athyeh in forum Access
    Replies: 3
    Last Post: 06-26-2013, 11:34 AM
  2. Need your ideas and help...
    By Daryl2106 in forum Access
    Replies: 8
    Last Post: 04-05-2012, 01:00 PM
  3. New to access, need ideas!
    By phenicie in forum Access
    Replies: 1
    Last Post: 12-27-2011, 05:55 PM
  4. Any ideas?
    By eripsni in forum Access
    Replies: 9
    Last Post: 08-25-2011, 08:33 AM
  5. Need some ideas
    By amauricio2 in forum Database Design
    Replies: 0
    Last Post: 03-02-2009, 11:03 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