CharlieKnight
IS-IT--Management
I have three databases, one list types of machines, one a list of contacts and the other a list of quotes made to entries of the contacts.
I'd like to show a list of the quotes made for each machine in the machine layout showing the quote ID number and the ID and Company name etc from the contact db.
The way I'd like it to work would be to say have 10 empty boxes in the machine layout and have a button next to each to created a new quote record. After the details of the quote have been completed I'd like a button in the quote layout to return the values into the empty boxes in the machine layout where I started from.
Hope this may make some sence to someone out there,
Many thanks in advance for taking a looks
regards
Charles Knight
P.S. I have managed to create a button that generates a new record in the quotes db and takes me to that layout, all I need is the difficult bit...
I'd like to show a list of the quotes made for each machine in the machine layout showing the quote ID number and the ID and Company name etc from the contact db.
The way I'd like it to work would be to say have 10 empty boxes in the machine layout and have a button next to each to created a new quote record. After the details of the quote have been completed I'd like a button in the quote layout to return the values into the empty boxes in the machine layout where I started from.
Hope this may make some sence to someone out there,
Many thanks in advance for taking a looks
regards
Charles Knight
P.S. I have managed to create a button that generates a new record in the quotes db and takes me to that layout, all I need is the difficult bit...