I know I asked this before, but I want to double check and REALLY get into it this time, sirs! I am former FPW2.6 programmer and jumping into VFP 6.0 in creating an new application :)

We are planning on creating an inventory application with VFP 6.0 and having the option for the user to see the picture(s) of an inventoried item. There can be 1 OR MORE images (pictures) PER ITEM.

Let's say we would have about 5,000 items recorded in the inventory application and we have 3,500 pictures OF THE 3,000 items. That means only 3,000 items have pictures and IN THOSE 3,000 items, some would obviously have more than 1 pictures.

Now, to be able to do this (as this is what "everyone" is telling me), I would need to create many many many directories for those images (*.jpg), such as:

M1111111 <1 image> copymach.jpg
thus:
P:\INV\IMAGES\M1111111\copymach.jpg

M1222222 <1 image> computer.jpg
thus:
P:\INV\IMAGES\M1222222\computer.jpg

M1333333 <2 images> desk.jpg and chair.jpg
thus:
P:\INV\IMAGES\M1333333\desk.jpg
P:\INV\IMAGES\M1333333\chair.jpg

and so on...

And then in the form, have a list box listing whatever (*.jpg) is in that directory of the same item ID. The list would show the name of the file (example in M1333333 - "desk" and "chair" in the list box). Upon clicking the name on the list box, the image would display (somehow and in "read-only").

In this example, I would have to MANUALLY create 3,000 sub-directories. Does this make sense to you or is this how you do it or is this what you would suggest???

I am posting this message in two places:
www.levelextreme.com as "Visual FoxPro in general"
comp.databases.xbase.fox

If you can not be of any help replying this, but want to help anyhow, you may copy this (or forward) to another VFP newsgroups or to your expert friends who programs in VFP. Thanks for any reply.

Chuck
CNT@bfs.uwm.edu

Today is tomorrow's yesterday.