Results 1 to 3 of 3
  1. #1
    akwormy is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    1

    structure advice?

    building a fairly simple database to serve as a shift log. date/time/initials/event details/follow up required check box all make up the table (and a primary key autonumber field)

    what I want is to be able to run a report for those things that need follow up - simple.

    then I want to be able to capture secondary information on the follow up - another set of date time initials and event details -

    should that be another table? Or in the same table?



    I took a shot at setting it up in the same table but when I tried to make a form that featured the original entries and the secondary entries it got so crowded that the text boxes required scrolling and it just didn't allow comprehension.

    I tried to find a way to have the text fields autosize but couldn't find something I was smart enough to implement.

    really appreciate any help on A) how to structure but mostly B) how to set up a form such that a person could have two potentially long memo fields (one from the first event and one for the subsequent follow up) that either autosized or maybe with a button that could at least open up that field in a broader view so you could read or type a coherent description of the event.

  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,816
    A) If you want multiple followup records for each event then have a related table

    B) Can set form to Continuous or Single view and arrange and size controls as you want. Did you use wizard to build form? The wizard 'groups' controls and this makes it a bit difficult to modify them. Select all the controls (use click/sweep) then right click > Layout > Remove.

    If you go with the 2 tables then use form/subform arrangement for data entry/edit.

    Might find this site helpful: http://www.rogersaccesslibrary.com/
    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
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    If they are the same structure , why not keep them both in one table?
    Maybe a flag to differentiate primary and secondary entries.

    No autosize available.

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

Similar Threads

  1. general advice needed on db structure
    By mike_980 in forum Access
    Replies: 5
    Last Post: 11-27-2013, 05:29 PM
  2. Advice on structure of VB Code
    By alsaf in forum Programming
    Replies: 2
    Last Post: 12-27-2011, 08:42 AM
  3. How to structure my db?
    By JeredG in forum Access
    Replies: 5
    Last Post: 11-14-2011, 06:22 PM
  4. Database Structure Advice
    By Douglasrac in forum Access
    Replies: 9
    Last Post: 07-16-2011, 07:14 PM
  5. Need advice on what I have so far
    By rumplestiltskin in forum Database Design
    Replies: 2
    Last Post: 05-25-2006, 12:48 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
  •  
Other Forums: Microsoft Office Forums