1. Purchase Order Table Design

Daily builds for smoke girl. Purchase order Database in SQL Server. This is in the design of a purchase order database I have 3 tables that were given to me by my accounting people I am new to sql.I think that the tables. Free Purchase Order Template & Instructions: How to Create a Purchase Order. By Crystalynn Shelton on November 6, 2017 Accounting Comments (0) A purchase order is used to request products or services from your supplier. It generally includes the details of the items that you intend to purchase, such as cost, quantity and description.

This is in the design of a purchase order database I have 3 tables that were given to me by my accounting people I am new to sql..I think that the tables need to be more tables and I am not sure what to do ..can you all give me some advice..I have been looking at the northwind db example and i am comfuse with my flow..here are these tables help me out you guys are usually great at help can you help me with my flow process as well.
tblvendors
Vendor
VendorID
Address1
Address2
City
State
Zip Code
Remit to address1
Remit to address2
remit to city
remit to state
remit to zip code
contact name
contact title
email
website
tblAssets
AssetId
AssetDescription
AssetCategory
VendorID
Model
ModelNumber
SerialNumber
DateAquired
DateSold
PurchasePrice
DepreciationMethod
DepriciableLife
SalavageLife
CurrentValue
tblPurchaseOrders
PO#
Vendor
VendorID
date
date requested
date promised
product ID
product description
account 1
qty ordered1
unit cost 1
product id 2
product description2
account 2
qty ordered 2
unit cost2
productid3
product description3
account3
qty ordered3
unit cost 3
product id 4
product description
account 4
qtyordered4
unit cost 4
product id5
product description 5
account 5
qty ordered5
unit cost 5
THis is it I hope you all can help. Thanks in advance and Merry Christmas to all
Boomer

I'm developing a php/mysql purchase order system and need some advice on how to approach the user interface. I'm learning and figuring things out as I go.

So when a user is entering line items into a purchase order it seems like right now they would be entering the item and quantity into a form text field and pressing the submit button. Then my php would sanitize and process the item into the database tables.

The php would then send out a new page with the updated line item.

It seems to me that this is fine for a basic method but there should be more elegant solutions. I haven't learned much javascript yet but I can imagine a script that would prompt a php script to do the sanitization and insertion and respond with the new position item and cost. This is beyond my abilities right now but I would be interested to know if that's the direction I should head.

Thanks for your help!

1 Answer

Apparently you need to look up the following:

• jQuery javascript library - you need this for functionalityhttps://api.jquery.com/

Purchase Order Table Design

Under jQuery, you will need to know

• jQuery.ajax (look it up here: https://api.jquery.com/jQuery.ajax/)
• jQuery.change (look it up here: http://api.jquery.com/change/)
• jQuery.html (look it up here: https://api.jquery.com/html/)
• jQuery.val (look it up here: http://api.jquery.com/val/)

After reading the above it should suffice to set you on the right path -- jQuery is awesome, take your time to read the docs and maybe some beginners tutorials! Good luck

Not the answer you're looking for? Browse other questions tagged phpuser-interfacedatabase-designpurchase-order or ask your own question.