Forum Academy Marketplace Showcase Pricing Features

Help with database retrieval

So I’ve made page that adds invoice data like invoice number total price items to the database I would like to make another page where u enter the put the invoice number into the input box and it fills out all the other data with what entry in the database matches that invoice number

You would usually structure this with an Invoice and Line item data types.

Your line item is your item with unit price, quantity, discount etc. this is added to your Invoice which is more like an basket/order at that point.

Once all your items are added, the order becomes an invoice, so it is your invoice that now holds the line items.

1 Like

How would I do that how can I contact you?

How did you get on?