Results 1 to 3 of 3
  1. #1
    Join Date
    May 2019
    Posts
    10

    Question Sharing Tables with other Tables - VB.NET

    Afternoon All

    I have come across an issue with sending data to my database which I'd appreciate some help on if possible. My knowledge of databases and how they talk to each other is reather limited so apologies if this is a stupid quesiton.

    Essentially I'm building a pretty big database with a VB.NET front end for generating quote for projects, and then makin those quotes 'live' when it is accepted and we can start work on the prohect. I can store information in table 'tblQuotes' no problem, but when I go to the next level I'm getting an error message about table 'tblProjects'. Now I can kind of understand why it's unhappy, but I'm a tad clueless as to how to get around this without duplicating dozens of tables, one set for Quotes and one set for Live Projects.

    As you can see, the information contained within Quotes and Projects is near identical (but this could change at that level as this develops), so it seems daft to double up the number of tables below.



    Any and all assistance most welcome.

    Thanks very much

    Graham

    Click image for larger version. 

Name:	Capture.jpg 
Views:	26 
Size:	96.8 KB 
ID:	42549

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I would just add a new date field to tblQuotes named ProjectApprovedOn (maybe also a text field for ProjectApprovedBy), move the ProjectRef field to tblQuotes and get rid of tblProjects. When you need to distinguish between Quotes and Projects just use the new date field to show Quotes (SELECT * From tblQuotes Where ProjectApprovedOn Is Null) or Projects (SELECT * From tblQuotes Where ProjectApprovedOn Is Not Null).

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I also suspect you don't need all those link tables, just include BuildersworksID, ContainmentID etc in your tblZones table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  2. Sharing of Access Database tables amoung multiple PCs
    By Lakecanters in forum Database Design
    Replies: 2
    Last Post: 01-02-2017, 07:49 AM
  3. Replies: 8
    Last Post: 07-21-2014, 03:35 PM
  4. Replies: 1
    Last Post: 12-11-2013, 01:18 PM
  5. Data Sharing within Tables?
    By clai in forum Database Design
    Replies: 1
    Last Post: 11-06-2009, 06:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums