Check out the group: http://groups.yahoo.com/group/helpwithvb/
and the books: Learn to Program with Visual BASIC 6 (comes with the Working model edition of that language) (ISBN: 1-5905-9151-8), Learn ot Program with Visual BASIC: Objects (1-9296-8516-5), and Learn to program with Visual BASIC: Databases (1-9296-8517-3). The three books build on each other, in that order, and the author of those three books manages the group I mentioned above. The three books develop exactly one project, and it is a kiosk application with a database. You can use the ISBN #'s (in the parenthesis) to find the books at any bookstore. The Learn to Program with Visual BASIC 6 will help you develop a very nice user interface with for the database, the objects book expands on the user interface, and the databases book creates the actual database for the project. (I own all three of those books, plus the fourth in the series: Learn to program with Visual BASIC: Examples 1-9296-8515-7 - but the "Examples" book does not even touch the project developed in the other three books.) Hope this helps! Alienwebmaster --- In [email protected], "Pete Harrison" <[EMAIL PROTECTED]> wrote: > > I am creating a new database for my brother who runs a food and wine > shop. > > It's going to be used for basic stock control and a in- shop 'kiosk' > type application showing a customer details about the product, an > image etc. > > Looking at the table design for the products table, many of the fields > for food or wine are the same (barcode, suppliers ref, product ref, > name etc), but then when it comes to the 'information', things go > wildly different, e.g. wine might have vintage, maker, vinyard, > whereas food wouldn't use these fields. > > It it best to have a products table for the common fields and > wine_details and a food_details tables for the particular details? > > Regards > Pete > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
