1 Reply Latest reply on Sep 3, 2010 11:07 AM by philmodjunk

    Multiple records in one portal

    RossJett

      Title

      Multiple records in one portal

      Post

      I created an inventory database to keep track of what's going into and out of our warehouse. As part of this, I wanted to have a form where a user can order new materials if we are running low on something. I made a purchase order form and as part of this, I wanted to have an area where users could enter in the product numbers of what they needed along with a quantity. Here are the tables I'm working with:

       Purchase Orders                 Materials

      po_number                          product_code

      date                                    description

      product_code                      price

      description

      price

      quantity

      total

      ordered_by

      office_id

      vendor_id

      In the Purchase Order Layout, I have a portal where I wanted the user to be able to enter in product codes along with quantities of what they needed in order to arrive at a total order amount. My problem is that I can't enter in multiple products in this portal. product_code is a foreign key in the purchase order table and a prime key in the materials table. Where am I going wrong?