Improving design

[gsb58@hotmail.com]

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@dley]

Re: Improving design

gsb58@hotmail.c om wrote:[color=blue]
> 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.[/color]

Use a subform.
[color=blue]
> Anybody that have ideas of what I should be aming for?
>
> Thank you in advance
>
> Me.Name[/color]
--
regards,

Br@dley

[gsb58@hotmail.com]

Re: Improving design

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....thank s for trying! :-)

Me.Name
[http://www.edu.utbnord.se/Geir/index.html]


Br@dley skrev:
[color=blue]
> gsb58@hotmail.c om wrote:[color=green]
> > 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.[/color]
>
> Use a subform.
>[color=green]
> > Anybody that have ideas of what I should be aming for?
> >
> > Thank you in advance
> >
> > Me.Name[/color]
> --
> regards,
>
> Br@dley[/color]

[Br@dley]

Re: Improving design

gsb58@hotmail.c om wrote:[color=blue]
> 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.[/color]

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.
[color=blue]
> Well, anyway....thank s for trying! :-)
>
> Me.Name
> [http://www.edu.utbnord.se/Geir/index.html]
>
>
> Br@dley skrev:
>[color=green]
>> gsb58@hotmail.c om wrote:[color=darkred]
>>> 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.[/color]
>>
>> Use a subform.
>>[color=darkred]
>>> Anybody that have ideas of what I should be aming for?
>>>
>>> Thank you in advance
>>>
>>> Me.Name[/color]
>> --
>> regards,
>>
>> Br@dley[/color][/color]

--
regards,

Br@dley

[gsb58@hotmail.com]

Re: Improving design

Hi!

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

:-)

Br@dley skrev:
[color=blue]
> gsb58@hotmail.c om wrote:[color=green]
> > 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.[/color]
>
> 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.
>[color=green]
> > Well, anyway....thank s for trying! :-)
> >
> > Me.Name
> > [http://www.edu.utbnord.se/Geir/index.html]
> >
> >
> > Br@dley skrev:
> >[color=darkred]
> >> gsb58@hotmail.c om 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[/color][/color]
>
> --
> regards,
>
> Br@dley[/color]