Verojay

Hello! Sorry for the total newbie question. So, I have 3 databases. One which I use as a portal, call this database A. I next have a Database 2, which contains the portal from Database A, along with an address area for contact info. The portal itself has a notes area you can add notes. Finally, I have an invoice. All three have relationships to eachother. I am going in circles trying to figure out how I can make Database B and the invoice database autoenter address info. The portal database (A), doesn't contain this info, so I wouldn't like to that, right? My mind begins to Shut DOWN after going around in circles...what the heck am I doing wrong?? Help! thanks.

Hello: I have a database set up for a client-top is basically contact info; bottom I have a portal that connects to another database which has notes on the client, by date. Each client has multiple records, based on project #. She wants a report to print up with status notes. I am having trouble setting up a report to ONLY show the last note added. I can sort the notes, to show the last note added, when you look at it in the regular view, however in the report view, it shows all of them, just in order of date. I only want to show the last note, not all, so when she prints up a status for a client it shows the most recent note for each project. Does this make sense? help!