So you need to make it simple, by allowing them to select an owner from a list… but you should still insert the OwnerID number into the field. And when you start creating databases that are absolutely jam-packed full of Foreign Keys, it’ll become more confusing then the Arabic translation of Stephen Hawking’s "Bumper Book of the Galaxy". In other words, it’s a number that links this particular record to a parent record in the Owners table.īut asking your end user to input an OwnerID isn’t very user friendly. If you remember, the OwnerID is a Foreign Key. For instance, if you wanted your users to enter new pets into the Pets table, your database requires a PetName, Breed… and an OwnerID.
Sure, we all know this is a family website, but the Editor’s on holiday in France this week so why not? …ĭo you remember all the bondage we encountered back in the distant realms of tutorial one? How we tied that text box direct to the database! We just added a data control, threw a few text boxes on a form, set a couple o’ properties… and hey presto, we’re up-and-running.īut with the wizzy database design you created last week, that just isn’t possible anymore. If you’re after a date, e-mail me – -))Īnyway, let’s get on with the show, kiddo…īinding, binding, binding. If you hate the series, tell us using the feedback form below.
If you love the series, tell us using the below feedback form. Oh, and don’t forget to tell us how we’re doing. Unfortunately we’re dealing with all the latest and greatest features, which only work with VB 6.0 yeah, I know, I’m sorry. We’ll then take a little look at validation before moving on to create a simple VB-integrated report.īut be warned, those with older versions of Visual Basic may feel about as comfortable as the passengers of infamous Flight 402, with the plane designed by La Augustus of Tower of Pisa fame, technically authenticated by Crazy Joe of Slackers Associated, and piloted by Kamikaze brothers Tun Twick Tang and Tun Twick Tang Junior. This week, we’ll be taking a sneak geek peek at how you can program your Visual Basic application around last week’s groovy database design. Guten Morgen and welcome to yet another instalment in this wizzy Visual Basic Database tutorial.Īs ever, I’m your stunningly geeky host Karl Moore and if you’ve missed any previous slots, check out:
0 kommentar(er)
