Looking to generate an invoice using product tables |
(02-21-2020, 12:53 PM)jreklund Wrote: Hi, It looks like you need up read up on how SQL relationships works. Here are one to get you started:Thanks for the input. I really don’t have an issue with the database relationships as I have been working with databases for over 30 years. My question is really about how to control the input from the users when they generate the invoice. I want to constrain the selections to only products that are in stock (visible through a view from my inventory tables). Ideally, the interface for the product drop down would be populated with “in-stock” products, and upon selecting an item, the primary key would be used to retrieve the item price from a pricing table and place the description, key and price into a HTML form or table where the user would simply enter the quantity (verifying that the quantity is less than the available inventory units). So basically, I want to have the user create the invoice by selecting a customer and then editing any changes to dates or delivery conditions. Once the customer data is entered, the record (last_id) would be used to populate the details form. I am looking for tutorials or documentation about passing a “master” key to a child form and then adding in rows of detail. I appreciate the help and I am very impressed with the community in this forum. |
Messages In This Thread |
Looking to generate an invoice using product tables - by emart53 - 02-21-2020, 12:23 PM
RE: Looking to generate an invoice using product tables - by jreklund - 02-21-2020, 12:53 PM
RE: Looking to generate an invoice using product tables - by emart53 - 02-21-2020, 01:36 PM
RE: Looking to generate an invoice using product tables - by jreklund - 02-21-2020, 02:11 PM
RE: Looking to generate an invoice using product tables - by emart53 - 02-21-2020, 02:45 PM
RE: Looking to generate an invoice using product tables - by jreklund - 02-21-2020, 03:30 PM
RE: Looking to generate an invoice using product tables - by InsiteFX - 02-22-2020, 05:41 AM
RE: Looking to generate an invoice using product tables - by alexis8 - 03-18-2021, 07:11 AM
|