A2000 Auction database - need help

[Matt Furze]

Hi, all,

I'm helping a friend with an auction database, and am stuck on this. Any
thoughts/suggestions would be appreciated!

Two tables - first is a table of Participants, with name, address, etc.,
including an ID number. Second table is a table of items, including
description, price, buyer #, seller #, etc. The buyer # and seller #
correspond to the ID number in the participant table. And participants can
be both buyers and sellers in the auction, or they may be only one or the
other.

What we want to do is produce a report when the participant checks out
showing items purchased, items sold, the amounts of each, and the net owed
the participant or net due from the particpant, depending on whether or not
he sold more than he purchased.

Any thoughts?

TIA

Matt

[Bas Cost Budde]

Re: A2000 Auction database - need help

Matt Furze wrote:[color=blue]
> What we want to do is produce a report when the participant checks out
> showing items purchased, items sold, the amounts of each, and the net owed
> the participant or net due from the particpant, depending on whether or not
> he sold more than he purchased.
>
> Any thoughts?[/color]

The general line of thought here might be:

* create a query that contains all information you want in the report,
but don't do grouping, sorting or totalling here (unless the resulting
group or total is a unit piece for the report). Create a report on this
query and group/order/total accordingly.

[Alan Webb]

Re: A2000 Auction database - need help

Matt,
A table is missing. You need a third table to tie things together. In that
table is going to be:
BUYER | SELLER | ITEM, and anything else relavent to the sale. Your items
table needs to just have the attributes of the item and not things like
buyer, seller, etc.
Now for a turn to my favorite subject, data warehouse design. You have an
Item dimension, a Participant dimension, an Event dimension (bid, end of
auction, sale, payment made, etc.), a Time dimension and probably some
others that escape me at the moment (Geography?). Your measured fact(s) are
sale price, fees, number of bids . . . dunno what you need. So that's four
tables with the fact table at the center.
If it's too late to change the schema then I'd do the first option and split
my item table into two--piece one would be item information and piece two
would be sale information like I describe above.

"Matt Furze" <mattfurze@cox. net> wrote in message
news:plbjd.8911 1$bk1.25078@fed 1read05...[color=blue]
> Hi, all,
>
> I'm helping a friend with an auction database, and am stuck on this. Any
> thoughts/suggestions would be appreciated!
>
> Two tables - first is a table of Participants, with name, address, etc.,
> including an ID number. Second table is a table of items, including
> description, price, buyer #, seller #, etc. The buyer # and seller #
> correspond to the ID number in the participant table. And participants
> can be both buyers and sellers in the auction, or they may be only one or
> the other.
>
> What we want to do is produce a report when the participant checks out
> showing items purchased, items sold, the amounts of each, and the net owed
> the participant or net due from the particpant, depending on whether or
> not he sold more than he purchased.
>
> Any thoughts?
>
> TIA
>
> Matt
>[/color]