By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

Improving design

P: n/a
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

Apr 20 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Apr 20 '06 #2

P: n/a
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


Apr 20 '06 #3

P: n/a
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
Apr 20 '06 #4

P: n/a
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


Apr 24 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.