Trying to add an order list to a form...
I'd like to make a form that sales reps would use to enter custom items to order. Basically a column for quantity, item number, etc. I would need multiple rows of these for entry, and I can't pull the...
Forum Discussion
no problem.
You will need to have a table called say Purchase Requests and then another table called perhaps Purchase Request Lines.
Then make a Relationship where 1 Purchase request has many Purchase Request Lines.
You will be able to show the Purchase request Lines directly on the Purchase request form as a list.
You will need to have a table called say Purchase Requests and then another table called perhaps Purchase Request Lines.
Then make a Relationship where 1 Purchase request has many Purchase Request Lines.
You will be able to show the Purchase request Lines directly on the Purchase request form as a list.
Also, would I have to "add item" every line, or could i just go down a row at a time, adding each item?