Search results

Sorry for the late reply. I have tried to no avail to arrive at the routing as the attachment, sorry I don't want to annoy anybody with my lack of knowledge, but I just don't seem to get it...as I said I am a newbie. If you have time (and the patience for me) would you have a look at the attachment?

Hi Everybody, Although I don't actually need it, (I may use the theory to create routing for my wedding cars) I am trying to create this attached DB from the works of Soren Lauesen. I create the tables, then the forms as instructed, When I try to fill in the form 'Leg' I keep getting the message...

Good points.. I will give it all a try Thanks again Bob

As I take a deposit, and then the balance a month before the wedding, would this do? TblInvoice InvoiceID (pk) BrideID (fk) TotalAmount Balance TblPayment InvoiceID (fk) Deposit Discount FinalPayment And then a query for the calculated balance???

Thanks for that, I know my database is NOT normalised, and I have to type in an address on several forms, sometimes repeating information, so I am going to change it all with your advice. Although I am 64 years old I am still enjoying learning from you all. Attached is a copy of my present DB...

Thanks Namliam, Does that mean each address should have several extra columns, in case that address is used for several types i.e. H(home) P(pickup) MV(marriageVenue) R(reception)... etc

My problem is each address could be more than one type. i.e. Correspondence, home, second, reception. I would need a form for the driver to receive his itinerary from.

I’m a newbie, and have gone round in circles to sort this out. I have a working database, but I know it’s all wrong! Basically I have a bride who hires my car. She has a correspondence address, maybe a pickup address, and maybe a second pickup address, a marriage address, and a reception...

A wise man speaks when he has something to say, and a fool when he wants to say something

Hi I am new to access, and am enjoying learning about databases, but at 63 years old am not as quick to pick thing up as quick as most. I hope to learn from your examples. I already am struggling with a few things.:o