Sure. So in the db, the user has the option to from a dropdown box to select from. to the right of that there is a notes section followed by hours worked then price per hour and finally total combined cost. When the first row data is entered, it allows to add a second row of information/products needed + hours, etc.
The issue im having, is when i open the invoice, only the first item entered from that drop down in that potal box shows up. i am unable to get the rest of the info from that drop down/portal.
I uploaded a sample image. Hopfully you can see what i am refering too
when i open the invoice,
What do you mean by "open"? Are you accesing a different layout at that point?
Please note that you have not yet described any tables, nor any relationships--both of which are needed in order for me to have any chance at being able to help you. More about how you have designed the layout--on which table is the layout based, on which is the portal based..., would also be very helpful.
I apologies for that. Ok so the two tables that are in relationship are "Purchase Orders" and "Line Items" There are two name fields in the Line Items table that im trying to show in the Invoice section, "ID_Products" and "Product Discription". The ID_Products is the one with a drop down. Both fieldnames arel located in a form based layout which its main table is Purcahse Orders. As i mentioned before, when one row is entered, it automaticaly allows you to enter another options in a row below the first.
Once the data is entered and saved, i have a button/link that would take the user to the invoice which main table is Line Items where all the data would transfer over. The invoice is basically a page that can be printed or email (Page size). The Layout is "QuoteRequest"
I hope this explains.