Re: Art Gallery Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

John -

Thank you for your response. It made me think about other aspects I should
consider (Persons table, etc.,) while I'm designing the database.

I am still floundering at a basic level however, and should tell you that
this is a real gallery that is currently presenting it's first show and I
have entered 1022 works in the database so far. There are also 90 artists
built in the member table. I would have liked to have had more time to get
all the tables and relationships, etc., built before I entered data, but I
did not have the time to do so. The one luxury that I do have is that we
are tracking all aspects of the show using the old, reliable - but time
consuming manual methods. This gives me a good comparison to build the
system that gives us what we need now, while envisioning and building for
our future needs. Hopefully all the inventory, sales, payments, taxes and
membership info will all be the same at the end of the first show.

Are there inherent problems in reworking tables and relationships since I
now have live data in the system?

I have made the changes to the inventory table that you suggested; renaming
it "Works" and moving the Price, TagNo and ShowId fields to the new
"WorksShows" table. Is there an easy way to migrate the data contents from
the old tables to the new? I assume that this would be the next step in
getting the tables set up and working. I'm using copies of the original
tables/data so that I have something to go back to if I screw things up.

I'm still having trouble getting the Sales table to relate to the TagNo of
the items being sold. I built SalesDetail with: SaleId from Sales (PK),
ArtId from Works (PK), Price (aren't I duplicating data though, since Price
is an existing field in WorksShows?). I want end up with a sales form that
allows the user to enter just the TagNo and have the form populate the
Artist, Title, Price and prompt for the next TagNo(s)., and then total the
sale, etc.

Thanks again - Mike





.

Relevant Pages

  • More questions
    ... consider while I'm designing the database. ... it "Works" and moving the Price, TagNo and ShowId fields to the new ... I'm still having trouble getting the Sales table to relate to the TagNo of ... ArtId from Works, Price (aren't I duplicating data though, since Price ...
    (microsoft.public.access.tablesdbdesign)
  • Sales Report
    ... I have a database in sheet A. the fields such as Sales Name, Product, Unit ... Price, etc. ... I would like to make the Sales based on Sales Name in Sheet B. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: September NPD is out:
    ... >>>> Of course now it's just a matter of maintaining sales. ... When Sony "eventually hits the $199 mark it will be ... drop the price, they may see a spike for a few weeks, but without enticing ... games on the 360 than on the PS3. ...
    (alt.games.video.xbox)
  • Re: Is Micro Focus doomed?
    ... So bean-counters plus management have arrived at a formula that gives them a 'safe' income by DEMANDING that you purchase those coupon books up front before you have even written a line of code. ... Now it could well be that the Sales Force is 'tied into a mantra', or as promoters/marketers for the products, just aren't doing their jobs properly. ... Certainly if radio/TV use music there are royalties - whether there is a package price paid up front, or from an audit the broadcasters pay after the event, I don't now. ... Next week it is Libbys that has a sales promotion, so in quick order Marketing dreams up another promotion. ...
    (comp.lang.cobol)
  • Re: Proper use of database splitting
    ... If it were me Id set it up as similar to a sales logic ERP program that a ... Main database backend on the server has everything. ... the process of doing this all of his customer records gets a CustCheckedOut ... Sales rep comes back with a boat load of sales and new accounts. ...
    (microsoft.public.access.formscoding)