info on every record in access database..

[bjames]

.....I'm having some trouble in designing an inventory database...hopefully
someone can help...

I'd like to create an inventory database where there is one record for each
item, then I would like to have the name, address etc., appear the same on
every record for that database. What is the simplest way to do this?

also...what is the easiest way to put pics in..i need 4 pics for each
record...is it to create an ole object field and embed an .bmp file?...thanks
for your help in advance...also..what is a good resource for learning this
programming? books? websites?

~brian

 

[jahoobob via AccessMonster.com]

If you want one address to be associcated with all the items in inventory
then I would create a table with that one address. Then I would combine the
Inventory and Address in a query:
SELECT Inv.ItemNo, Inv.ItemDescrip, AddressTable2.Addr
FROM Inv, Table2;
This way, if anything cahnges in teh address e.g. company moves, you have to
change it only once, not in ecah record and it takes up less room in the db.
If you will always use the pictures when you open the inventory table then
place Pic1, Pic2, etc. as fields in the Inventory table. I would link the
images and not embed them.
If you are going to work a lot with the inventory table without needing the
pictures then I would have a separate table of the pictures linked to the
Inventory table via the ItemNo.

 

[John Vinson]

....I'm having some trouble in designing an inventory database...hopefully
someone can help...

I'd like to create an inventory database where there is one record for each
item, then I would like to have the name, address etc., appear the same on
every record for that database. What is the simplest way to do this?

By storing the name and address (of the inventory item...? or the
recipient? or what?) in A DIFFERENT TABLE, a table of addresses; and
using a Query to link the inventory table to the address table.
Storing the address repeatedly in every record is simply bad design
and unnecessary.

also...what is the easiest way to put pics in..i need 4 pics for each
record...is it to create an ole object field and embed an .bmp file?...thanks
for your help in advance...also..what is a good resource for learning this
programming? books? websites?

Check out the many, many resources at http://www.mvps.org/access and
at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

Espcially note the "Database Design 101" links on the Access Junkie's
site.

John W. Vinson[MVP]

 

[bjames]

Thank you for your response jahoobob....

so when I am entering data in...I jus put the info once in a table...and
then create a separate table for the inventory items?...and then how do I put
them together on a form...or when i run a report?....essentially I will be
giving this to the person who the inventory was done on in CD form....so i
should have the database on there and then an folder for images?...again
thanks for your help with my newbie questions..

 

[jahoobob via AccessMonster.com]

If you use a separate table for the pictures, you will enter the inventory
items in a main form and enter the pictures via a subform linked to the main
form via the ItemNo. The main form will be Single and the subform will be
Continuous.

I would store the images in the same folder as the database.

As far as putting things together you will be doing this in a query:
SELECT Inv.ItemNo, Inv.Item, Addr.Address, Images.Picture
FROM Addr, Inv INNER JOIN Images ON Inv.ItemNo = Images.ItemNo;
the query output would look like this (I hope it is formatted so you can tell)
:
ItemNo Item Address Picture
1 Widget Home Package
1 Widget Home Package
2 Gadget Home Package
Of course in a report you would group by ItemNo or Item and Place the ItemNo,
Item and Address in the Group Header and teh pictures in the detail so you
would get only on ItemNo, one Item, and one Address with all the pictures.
Hope this helps,

Thank you for your response jahoobob....

so when I am entering data in...I jus put the info once in a table...and
then create a separate table for the inventory items?...and then how do I put
them together on a form...or when i run a report?....essentially I will be
giving this to the person who the inventory was done on in CD form....so i
should have the database on there and then an folder for images?...again
thanks for your help with my newbie questions..

If you want one address to be associcated with all the items in inventory
then I would create a table with that one address. Then I would combine the

[quoted text clipped - 23 lines]