I have been out of the php/mysql thing for a long time and totally forgot most of what I learnt years ago but have a new project. I want to know the best way to approach a po system from a structure point of view I have an order table and an item table. I need to build a form that takes the main order info then can add multiple line to the item table. I was told by a friend in access its called a continuous form and wondered how its done in php/mysql so I can look up how its done ?
Purchase Order System
As far as i understand you looking to create an order form in one table then items in other table.
When you submit order form then insert all values in order table and put one unique id.
Using that unique id(using session you can use this unique id on all pages this will help you to retrieve or store data in items table) you can create multiple items in item tables. Like you add five item for this order then ordernumber for all these will be same(mean unique id).
That is spot on but I need a rough idea on how the form is created I can do a standard from with one item at the bottom or in fact several item by just repeating the code but with the addition of a different item number. I can store the unique id of po number and just insert it into each item record. My q really is how do I create a form that can add multiple items it could be from 1 to say 100 items on the po ?