order system for access

[Smatick]

I have downloaded the template for access that is for ordering. I like the
way it is set up, but I need it to do some more stuff in a way and cannot
rem. how to get it up. what I need is when I pick a product I need to be able
to select the options the people want in the item. I sell manufactured homes
and I am trying to make the paperwork easier us. any help in this issue would
be great.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d27&dg=microsoft.public.access.tablesdbdesign

 

[Rick B]

Templates are simply starting points. You would need to modify it to meet
your specific needs. I doubt tit would be worth Microsoft's efforts to
modify the template to work for the manufactured home industry. That is
pretty specific and templates are designed to be generic.

 

[Smatick]

Is there any chance you could refresh my mem on how to get it set up? if has
been about 4 years from when I learned access and I have not used it in that
time.

 

[Rick B]

Not from your post. You would need to explain exactly what you are trying
to accomplish and what your current structure is. I do not have the
template you mention, so I don't know what the tables currently look like or
what the form looks like where this selection would take place.

I'd assume you'd need to add at least one additional tables with these
optional items and then somehow relate them to the main table. This will
most likely be a many-to-many relationship where a particular "option" is
available on several "models" and each model has multiple options available.

In short, we can help you answer specific questions, but your's is very
broad.

 

[mnature]

You will have to create some new tables, link them in relationships window,
set up some queries for those tables, and then set up some forms. Lots of
stuff to do. Start with creating new tables and linking them.

It sounds as if an Orders Table already exists (I will assume that there is
something equivalent to an OrdersID for this). You will need an options
table, which will list all the possible options that are available. I will
assume that all of the options are available for all the manufactured homes.
If that is not true, you will have to further modify things, but this should
get you started.

tblOptions
OptionsID
OptionsName
OptionsDescription

This table will be tied in to your Orders Table through an intermediate
table.

tblOrdersOptions
OrderOptionID
OrderID
OptionsID

Each Order ID can then have multiple Options ID's tied to it, and each
Option can be assigned to multiple Order ID's. This assumes that each
manufactured home you sell has a unique Order ID associated with it.

Now you need to link these tables together, make some queries based on
tblOrdersOptions, and then somehow modify an existing form, or create a new
one, that will display this new information.

I have tried to designate when I am making assumptions, since I don't know
the exact layout of your current database.