April 18, 200718 yr Newbies Hi, First post - here goes, I have a database where i add notes for appointments, what i would like is when i create a new appointment which is linked to a client, go to the notes section and add new notes for that appointment but to also have maybe a portal?? showing all notes from previous appointments (maybe even when you click on a portal row, the notes fields displays that record). many thanks in advance. Eric.
April 18, 200718 yr He Eric and welcome to the forums. Make a self join relationship where you put another table occurence of your appointments table, keying on the ClientID. Then you can create a portal that will use the new relationship and put on the related Notes field. This will display all the client's other appointment notes. If you want a way to go to a particular note's appointment record. Create a button and use the Go to related record step.
April 18, 200718 yr Author Newbies Many thanks, just sussed it as well, Thanks again-what a brilliant resource
Create an account or sign in to comment