6 Replies Latest reply on Mar 6, 2017 6:07 AM by mikerevans

    Need to create multiple fields in the same record that reference the same table.

    mikerevans

      Hi,

       

      I'm a total noob and I am trying to write a Work Order system. The problem I am facing is that I am trying to create multiple tasks in one record, that reference the same table, the choices are made via drop down lists.

       

      i can get the first task created via drop down lists. The tasks at the moment consist of :-

       

      Category

      Item

       

      The Item drop down relates to the choice made in the Category drop down.

       

      My woes begin when i try to add another task :-

       

      Category1

      Item1

       

      I find that I cannot get Item1 to reference Category1, at best it will always reference Category.

       

      Sorry if you do not understand but I have AS.

       

      Please can you advise?

       

      TIA

       

      Mike