Supply form problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database i have inheriated from an employee that is no longer at my
company. A supply database was created for purchases that only allowed 1
item on each form, no matter how many itmes needed to be ordered under that
job.
What i tried to do was to create additional lines in the form for more than
1 item for listing.
I did this by creating more fields in the table, model num1, desc1, price1,
qnty1, fullprice1 and so on for a total of 5 lines.
this was a bad idea as other queries and forms will have to be modified to
look at the new table fields.

is there a way to have multiple line items in the form, up to a maximum of 5
lines, and have the form put them in the same field, just the next line of
the table.
i am guessing it can be done with subfields, but i have no idea how it is
done.
My skill lvl in coding is very minimal.

Thanks for your help
Carl
 
Is this a purchase order database in which one pruchase order may have more
than one item. If it is then you can do it with two tables and two forms.
One table would have the purchase order info including the Purchase Order #
as the primary key. The second table would have the item information as well
as a Purchase Order # as a foreign key.
Your first form would have the Purchase Order info on it and be a Single form.
The second form would have the item info on it and be a Continuous form.
Place the item form in the Purchase Order form as a sub-form with the link
being the Purchase Order #.
When you enter a Purchsase Order yu can enter as many items as you want and
they will all have the PO# in the record so you can tie the two together.
If you need more specific info, ask,
Bob
 
Back
Top