none
Table field with data entry options RRS feed

  • Question

  • I am working on designing a database for our engineering department schedule.  Each project has its own line in the table.  I want to be able to populate a drop down field that they can put in information regarding plans.  Some projects would have one maybe two entries and others would have much more.  I created a form for this.  I do not know how to make it one, attach to a field and two, to make it have new records for each job.  This may not be the proper way to do this.  Any help on this would be greatly appreciated.
    • Edited by JMuellerSBI Tuesday, December 13, 2016 3:30 PM
    Tuesday, December 13, 2016 3:29 PM

All replies

  • You'd need to create related tables for such a scenario, not one single table.

    So you'd have a Projects table

    Projects
    ******************
    ProjId
    ProjName
    ProjLeadId
    ...

    and then create a Projects Jobs table

    Projects_Jobs
    ******************
    ProjJobId
    ProjId
    JobName
    JobStatusId
    JobStartDate
    JobEndDate
    ...

    Then you'd have a Projects form in which you would insert a Job subform (in continuous mode) to allow you to enter the various jobs relating to the Project.


    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, December 13, 2016 3:44 PM
  • Hi, Sounds like you have a one to many relationship between schedules and plans. If so, the common approach is to use a form/subform approach. Hope it helps...
    Tuesday, December 13, 2016 3:49 PM