Search results

Thanx for your time in replying. It is possible to have a CoLoad that isn't full and also a full load that isn't a CoLoad. The "CoLoadWith" field I had included, so that I could see which customer ("Organization") the load was sharing with. The Yes/No field for "CoLoad" was so that I could find...

I have a Dbase set up and ready to roll, but I haven't actually created the Dbase yet with Access. I would very much like your opinion on my table layout and relationships. You can view the design here I am hoping to track shipments in and out, plus current stocks of items using Queries and...

Thanx a lot for your informative reply. I will definately take your advice. Thanx for your time

I am almost at the finishing line with a great deal of help from here. I have now normalised the tables, built complicated queries, forms, reports, all from scratch as I knew absolutely nothing before I started with Access three months ago. I have compacted and repaired the database using the...

Having studied the link that you kindly included in your last post, I will have to do some serious thinking as to substituting the tables Allen Browne has and mine. Also, do you think I should change the field "Product" in the "tblShipments" to a foriegn key linking it to...

I see now that I was trying to store a calculated result. Silly me. Being new to this I am trying to get the current Product Stock figures after Adding "tblProducts.LMStocks" to the sum of "tblProduction.Quantity" (per Product) and then Subtracting "tblShipments.NumOfPallets" x...

I know nothing of SQL, the following code is what appears after I made the query in design view then switched to SQL view; (I named the query "qryProductsShipped") SELECT DISTINCT tblShipments.Product, tblShipments.NumberOfPallets, tblShipments.PartsPerPallet, [NumberOfPallets]*[PartsPerPallet]...

Ahhh. I think I get your drift now. I would make a query with two instances of the same table "tblComponent" and "tblComponent_1" and then create a join between ProductID and ComponentID. With ComponentID being the RowSource.

While studying your suggested table design further and reading your logic, I am afraid I'm missing the point about the "ComponentID" field. Do you mean that ComponentID is just for Query purposes, or is it a foreign key? I have worked out that I could now remove the tblStoredComponents and just...

Brilliant! Superb! It is only with your help that I am now beginning to grasp the idea of using Queries instead of making "redundant" tables. I see where you're coming from with the extra fields in the shipments table so as to be able to get rid of the "tblBookedShipments", and since you point...

I need to be able to track (see) shipments booked with which haulier and to where and when etc. Sometimes the Haulier fails to deliver on time and I always email bookings to the haulier just to cover my ass with the boss. So that if a delivery fails to get there on time at least I have a record...

You got it in a nutshell. That's exactly what I meant. It isn't easy trying to convey my intentions with just plain text on a plain background, without inflexions in the voice. Anyway, I have done a new table design and if you could find the time to look it over I would be most grateful. You may...

Yes I got that. That's why I couldn't figure out how to store the Primary Key of TWO Organisations in the ONE record of the Shipment Table, as I had the Customer and Haulier fields set as Foreign Keys that linked directly to the Organization Table. But by doing it the way you said, I can have...

Brilliant! Thanx for the input. I now realise that basing forms on Queries gives me more flexibilty. Thanx. I can filter the data using queries for forms so as to separate Hauliers Suppliers and Customers, but I still dont understand how I can have TWO Organization IDs on ONE record of the...

I have maybe you need to refresh the page. I have One contact table and one address table, and One Organisation table

Thanx for your reply, I have trimmed-down the tables to what I think is Proper normalization, but I still can't see how to relate to a Customer (Organization) AND a Haulier (Orgainization) in the Shipments table. Updated jpeg of relationships here

I have a Table Structure that works fine, but I want to trim it down a little. I know that a few tables aren't normalised properly. Three of the tables (tblCustomer, tblSupplier, tblHaulier), could be trimmed down to two tables (tblCompany) with a link to (tlkpCompanyType). This would then allow...

Thanx very much for pointing me in the right direction. The OpenArgs Property did the trick. I knew there must have been an easier way! But being a complete novice at coding and Database building I was struggling. It's only with some great help and advice from here that I have managed to get as...

I have a simple form with a Combo box on it acting as a drop down list so the user can select a customer name. Once they select a customer name they click a button on the form to open a report based on the customer they selected. All works fine. The problem is, there are 41 customers to choose...

Thank you both for replying. I am a "dumbo", I should have posted that I have found the solution by searching through this forum. I get too impatient sometimes. I am sure I will need the services of this great knowledge source again in the not too distant future. Thanx again for replying p.s...