Recent content by petervine

Thanks Jonathan for the reply and your solutions. That is exactly what I am looking for! I shall use the code from your second example. Now at least I can stop taking the headache tablets! Pete

Thanks for the explanation of the terminology Supertype / Subtype. So it seems that my basic table structure is OK. The one to one relationships are correct and all is normalised. This then leads me back to the original question which now I know of the existence of subtype / supertype tables I...

Thanks Leslie for running with this. OK. Here’s the table structure as it stands at the moment. There are 3 couriers, ANC, Parcel Line & FedEx. Their details such as address, phone number, etc are recorded in TblSuppliers which is not involved in this scenario. TblOrders OrdersID (PK) (Auto...

Thanks for the reply Leslie. Yes I did review the Fundamentals document. Infact I have printed it out and read it several times and would recommend it to anyone else starting out in data base design. I understand the many to many relationship you have outlined, but I still cannot get my head...

Thanks very much Croley16, Johnherman and Lespaul for your replies. I except I’m being a bit slow here but there are 2 areas that I still can’t quite see. Could you explain a little further please? My original idea was to put the common fields of the 3 courier companies into TblOrder and the...

Hi I am relatively new to access (and this forum!) and wonder if anyone could please help with the following: In this scenario there are 4 tables, TblOrders and TblCourierA, TblCourierB and TblCourierC. The Courier tables are amongst other things to be used for basing a report on to print the...