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