ASSIGNING MANY ITEMS TO ONE NUMBER

[Guest]

Is there a way to assign many Inventory numbers to one customer. And many
prodcuts to one inventory box number so that when you are entring the
information in a form you do not have to repeatedly enter the customer # or
the box number?

 

[Norman Yuan]

That is how you design your database: Customer, Product, Order... all should
be in seperate table as an data entry. Then you find out the relationship
between entries, such as a Customer could have 1 or more orders, an order
includes 1 or more products, a product can be in 1 or more orders...

If your database was designed correctly (not just a huge flat table), you
would have the answer to your question.

 

[Joseph Meehan]

Is there a way to assign many Inventory numbers to one customer. And
many prodcuts to one inventory box number so that when you are
entring the information in a form you do not have to repeatedly enter
the customer # or the box number?

Sure. It should be done that way. In Access you create related
databases. Think of if as parents and children.

The final design may vary but in the family idea you might have one
table for families, one for people each person is related to one (maybe more
than one depending) families. People are in a people table. So each family
will have a relation to one or more people each person will have a
relationship to one or more families Likely the address will be just one
for the family, but telephone numbers will attach to each person (cell
phones).

In any case you have to divide them up. In a spreadsheet you would just
keep adding new columns and rows, but not in a database. BTW some modern
spreadsheets allow you to setup relationships as well.

Take a look at the Northwind database that is usually part of every
Access program, it has some examples. You may want to take a look as some
references as well, look for "Normalizing Tables or Data"

 

[Guest]

I have a seperate table for products, box numbers, and tent #s. So how do I
set things up so that I don't have to pull down tent #2501 60 times when I
match a box number to it or When I need to assign 12 items to box 78987 how
in a form do I do that without having to store box 78987 12 times?

 

[Joseph Meehan]

I have a seperate table for products, box numbers, and tent #s. So
how do I set things up so that I don't have to pull down tent #2501
60 times when I match a box number to it or When I need to assign 12
items to box 78987 how in a form do I do that without having to store
box 78987 12 times?

"Alt" "quote" should copy the prior value when adding a new record.
Just get the focus in the correct field and press "alt'"

 

[Guest]

So if I am in want to use the same box number for jumping jacks as I did for
sparklers, I go to the box number field and press alt and it will repeat?

cool, i will try it

 

[John W. Vinson]

So if I am in want to use the same box number for jumping jacks as I did for
sparklers, I go to the box number field and press alt and it will repeat?

Not quite: hold down the "Alt" key and press the ' key (next to the
Enter key on my keyboard).

As noted, however, a Form with a Subform would be a better approach.

John W. Vinson [MVP]

 

[Joseph Meehan]

Not quite: hold down the "Alt" key and press the ' key (next to the
Enter key on my keyboard).

As noted, however, a Form with a Subform would be a better approach.

John W. Vinson [MVP]

I agree.