Search results

I've done a lot of reading on normalization, but I'm having a hard time grasping some of the concepts. Especially how to use foreign keys and junction tables. Let's say I have a DB where I keep track of bicycles. I have a table, 'tblBikeInfo' with a lot of fields containing info about each...

I'll try to be as brief as possible. The client wants to be able to add/remove items from an invoice by clicking small 'plus/minus' buttons. I've accomplished this by making one table which contains orderID and the name of *all* spare parts, then hooking up each pair of buttons on the form to...

Hello everyone. I'm a self-taught guy from Scandinavia. I've dabbled in several languages, like html, css, C#/C++ and Python. Recently, I landed a position as a trainee working with Access, SQL and VBA.