Group and add a reference Number

S

sam

I have a list of orders for items for various suppliers. SOme have just one item for a particular supplier some have multiple. What I am wanting to do is group all the items going to each supplier and add a reference number to those items ie. all items to come from supplier A to be given a reference number of 12345. I need to be able to add this number to the order table. Anyone have any ideas how I can achieve this??
 
T

Tom Ellison

Dear anonymous:

If you want the reference number for supplier A to be 12345 for every
order then you do not need to store this in every line of every order.
Simply store the reference number once in the record of every supplier
and JOIN to that. Just how would depend on your current data design.
Do you already specify supplier in every line of every order? Or is
supplier specified through the item ordered?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
S

sam

Hi
One item can come from a number of suppliers. I want to use the number as basically a requisition number so it must change from order to order. All items ordered from supplier A (this time) will be under one number, next time it should be a different number. Think of it as a requisition, one requisition containing numerous items for one supplier. I need to find a way to add a number to this group. When receipting is to be done I need to be able to call up this number and receipt the items which is another matter but simple enough. I just can't think of a way to group the items by supplier and add a unique number to the group.

----- Tom Ellison wrote: -----

Dear anonymous:

If you want the reference number for supplier A to be 12345 for every
order then you do not need to store this in every line of every order.
Simply store the reference number once in the record of every supplier
and JOIN to that. Just how would depend on your current data design.
Do you already specify supplier in every line of every order? Or is
supplier specified through the item ordered?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Top