Opening a new record with information from another table
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.