Improving design

[gsb58]

Hi!

I was thinking on building a kind of shopping system you see on
webpages in an access 2000 database, instead of using an
Order/OrderDetail form solution.

I would use a listbox to fill with Categories, but how could I solve
Item side? Obviously I can use a listbox there too, with multiple
choices set to extended. But user must be able to specify amount of
each item he/she chooses.

Anybody that have ideas of what I should be aming for?

Thank you in advance

Me.Name

[Br]

gs***@hotmail.com wrote:

Hi!

I was thinking on building a kind of shopping system you see on
webpages in an access 2000 database, instead of using an
Order/OrderDetail form solution.

I would use a listbox to fill with Categories, but how could I solve
Item side? Obviously I can use a listbox there too, with multiple
choices set to extended. But user must be able to specify amount of
each item he/she chooses.
Use a subform.
Anybody that have ideas of what I should be aming for?

Thank you in advance

Me.Name

--
regards,

Br@dley

[gsb58]

Hi!

Thank u for answering.

A subform was not what I really had in mind. Because I was thinking of
inserting items chosen from this basket into a Master/Detailform. With
a subform u could of course go there and add amount, but then we're
back at the Master/Detail solution.

My aim was more like making it more "easier" to fill out an order than
the regular way with an Order/Detailform, like when u go to amazon.com
and add items to the basket.

Well, anyway....thanks for trying! :-)

Me.Name
[http://www.edu.utbnord.se/Geir/index.html]
Br@dley skrev:

gs***@hotmail.com wrote:

Hi!

I was thinking on building a kind of shopping system you see on
webpages in an access 2000 database, instead of using an
Order/OrderDetail form solution.

I would use a listbox to fill with Categories, but how could I solve
Item side? Obviously I can use a listbox there too, with multiple
choices set to extended. But user must be able to specify amount of
each item he/she chooses.

Use a subform.

Anybody that have ideas of what I should be aming for?

Thank you in advance

Me.Name

--
regards,

Br@dley

[Br]

gs***@hotmail.com wrote:

Hi!

Thank u for answering.

A subform was not what I really had in mind. Because I was thinking of
inserting items chosen from this basket into a Master/Detailform. With
a subform u could of course go there and add amount, but then we're
back at the Master/Detail solution.

My aim was more like making it more "easier" to fill out an order than
the regular way with an Order/Detailform, like when u go to amazon.com
and add items to the basket.
I only difference there is it's a web interface and so it is more linear. It
is still an order/detail design just that the order info is entered on a
previous web page. So all you need to do is mimick the process (ie. bring up
seperate forms (or use paging on the one form) so it appears like the web
intereface.
Well, anyway....thanks for trying! :-)

Me.Name
[http://www.edu.utbnord.se/Geir/index.html]
Br@dley skrev:

gs***@hotmail.com wrote:

Hi!

I was thinking on building a kind of shopping system you see on
webpages in an access 2000 database, instead of using an
Order/OrderDetail form solution.

I would use a listbox to fill with Categories, but how could I solve
Item side? Obviously I can use a listbox there too, with multiple
choices set to extended. But user must be able to specify amount of
each item he/she chooses.

Use a subform.

Anybody that have ideas of what I should be aming for?

Thank you in advance

Me.Name

--
regards,

Br@dley

--
regards,

Br@dley

[gsb58]

Hi!

Thanks again. That is of course one way to do it. I'll give it some
hours over the weekend

:-)

Br@dley skrev:

gs***@hotmail.com wrote:

Hi!

Thank u for answering.

A subform was not what I really had in mind. Because I was thinking of
inserting items chosen from this basket into a Master/Detailform. With
a subform u could of course go there and add amount, but then we're
back at the Master/Detail solution.

My aim was more like making it more "easier" to fill out an order than
the regular way with an Order/Detailform, like when u go to amazon.com
and add items to the basket.

I only difference there is it's a web interface and so it is more linear. It
is still an order/detail design just that the order info is entered on a
previous web page. So all you need to do is mimick the process (ie. bring up
seperate forms (or use paging on the one form) so it appears like the web
intereface.

Well, anyway....thanks for trying! :-)

Me.Name
[http://www.edu.utbnord.se/Geir/index.html]
Br@dley skrev:

gs***@hotmail.com wrote:
Hi!

I was thinking on building a kind of shopping system you see on
webpages in an access 2000 database, instead of using an
Order/OrderDetail form solution.

I would use a listbox to fill with Categories, but how could I solve
Item side? Obviously I can use a listbox there too, with multiple
choices set to extended. But user must be able to specify amount of
each item he/she chooses.

Use a subform.

Anybody that have ideas of what I should be aming for?

Thank you in advance

Me.Name
--
regards,

Br@dley

--
regards,

Br@dley