Results 1 to 7 of 7
  1. #1
    CaliberGX is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Posts
    15

    Question on Form creation

    After finishing my previous step now I have a query of how is best to structure the data and create a form.

    I can structure the date in the below two ways.

    1st Way

    ID (PK) Initials (FK) Product Type Score Comments

    2nd Way

    ID (PK) Initials (FK) Product1 Score Comments Product2 Score Comments


    I know for sure that there will be only 4 kinds of products and they will never increase. The thing is if I use the first way I do not know how I would structure the Form so that it would show all 4 products and have bound fields to fill in their score and the comment. Any ideas on how I should structure it ?



    Thank you for your help in advance.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    A lot depends on the purpose of the form. Is it for display only or will there be changes to the data? Never predict the future!!! How many systems have we worked on where the user says that but then changes their minds? Unless this database is a one-off and itself will be defunct in a month's time.

    The second method would not work for data changes and would be a crosstab query shown in datasheet view on the form. The first is way more flexible and you can show the data singly, on continuous form or in datasheet view. Plus changes can be made to the data in the first method.

  3. #3
    CaliberGX is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Posts
    15
    The thing is that I am sure there will be no changes in that table ever. I know the first method is the best to use. But if I use that method how will I create the form. The form will be used for Data Inputting.

    But I think I got an Idea. I can make a continuous subform on my main form which will link the FK with the PK of my main form and then I will have a value list for the Product Type that will have a list of the products. Is it possible to add some sort of way so that each product type is used once only ?

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    That is a good way of doing it.

    What do you mean "used only once"? Is this on the table that is the record source of the subform, or the record source of the main form? Maybe it would help if you add a bit of an explanation of your process.

  5. #5
    CaliberGX is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Posts
    15
    I will have a value list with the 4 set values of the products they will need to choose. I want to make it so that they have to choose all 4 of them in the continuous form and choose only one time each of those products.

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Manually add the 4 records to the table and then never allow them to add another. If they do need to add another in the future they can add it manually.

  7. #7
    CaliberGX is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Posts
    15
    Thanks a lot after trial and error I managed to do it as you said above ! thanks a lot

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

Similar Threads

  1. Serch Form creation in access
    By aparnawangu in forum Forms
    Replies: 2
    Last Post: 09-22-2015, 06:27 AM
  2. Search/Edit form creation
    By Hagridore in forum Forms
    Replies: 11
    Last Post: 01-21-2015, 11:17 PM
  3. Replies: 8
    Last Post: 07-18-2013, 01:52 PM
  4. Beginner struggling with form creation
    By audmkamp in forum Forms
    Replies: 1
    Last Post: 01-22-2013, 01:40 PM
  5. Table and form creation
    By Andyjones in forum Forms
    Replies: 2
    Last Post: 12-31-2011, 10:27 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