creating a button that takes you to a layout in a different table
Im creating a database to be able to update and keep track of sales orders and purchase orders. My sales and purchase order layouts have portals to keep track of more than one item per record. Within my sales order layout I have a purchase order field and I would like to make this field into a button that takes me to that purchase order record in my purchase order layout (which is in a different table). So far the button takes me to the purchase order layout but not the corresponding purchase order records. Im sure it has something to do with the relationships I have or have not set up. Can someone PLEASE help me figure this out???
Thanks in advance!!!