Search results

I have set up some tables as shown in the diagram below but I am having a problem with queries. I want to end up with a continuous form that will hold a substantial number of fields (51) for each shipment (most of the data will come from other tables but 11 pieces of data come from the left...

I have 2 tables as follows; Shipments .................Invoices SId (PK)......................IId LoadNumber ................S_SId CargoId ......................InvoiceType (10 Types) ContractId ..................InvoiceSubType (4 Sub Types) Etc ............................DateReceived...

Hi, I have been working on this since last October (on and off), without success:(. I have two tables as follows: Shipments .................Invoices SId (PK)......................IId LoadNumber ................S_SId CargoId ......................InvoiceType (10 Types) ContractId...

I have a complex union Query which works exceedingly well in an unsplit database. It is based on around 20 other queries which are in turn based on a number of tables and queries. This feeds a form which sumarises the status of every aspect of the db in one page.:) Problem is when I split...

Hi, I have been working on this issue for several weeks without success, any assistance would be much appreciated. My database tracks the invoices related to shipments, each shipment can have as many as 20 different invoices raised against it, but not all shipments have the same invoices...

Hi, I'm developing a database with which to manage shipments of materials. This process involves a large number of invoices changing hands, some incomming and others outgoing. I normalised the DB and have a table called invoices which has the following fields; Invoice ID (Auto Number)...