I am creating an inventory tracking and order form.  The place order form is a stateless form that updates my order form table and orders table.  I am trying to create a form that an associate can enter their name and shipping information and order multiple items.  The shipping info will update the order form (form) and the items will update the Orders table (form).
Also, I need to create a keyed OrderID auto number to tie the order form and orders table  together.

Is this possible with ZOHO creator, If I can achieve this I will sign up as a paid account.  If it's not possible I will have to look for a different solution.  Once the app is created I need to provide restricted access to my associates to just the total inventory report and the Place order form.
 Any assistance you can provide will be appreciated.  I am open to contracting a developer on this, if I can get the functionality I need.