AnsweredAssumed Answered

Opening a new record with information from another table

Question asked by PaulCane on Mar 14, 2013
Latest reply on Mar 14, 2013 by philmodjunk

Title

Opening a new record with information from another table

Post

     The database I am in the process of making, contains customer information, and machines that they have installed at their premises I've made a dropdown menu that takes the user to a layout that has a portal showing all machines that the customer has, 

      

      I'd like to put an invisible button over the top of the portal records, so that when that record is "clicked", it will take you through to a service layout, and make a new record, and put the relevent information in to that layout.

     Structure-wise The customer key is called customerID

     machine is MachineID

     and Service is ServiceID

     Making the button isn't a problem its just the scrip ;)

      

     Any help will be much appreciated.

      

      

     Regards

      

     Steve

      

      

Outcomes