Search results

From this statement: Once I have all the details required I send this information to the Storage supplier and request a Booking in Date / Time and Reference for the Suppliers haulier to arrive with the goods. It is not clear : -who divides a shipment into Lots. - I do, it is a requirement of...

Nick --Fruit Management --CallOffContracts. Draft rules: (these are preliminary and need to be refined and vetted) Our company deals with many Suppliers Many Contract(s) are set up with a Supplier A Contract defines the Products and Quantities to be Supplied (other Terms/conditions?). No other...

Hi Mike That looks great and is definitely most of the way to where I want to go with this, I will study it properly and see what I need to do to finish it off. I am very encouraged that my structure for the tables seems to work. Many Thanks

Hi jdraw OK, will remember for future postings. Regrading Purchase Orders they are one and the same, some are placed with an end date 12 month or more some times in the future [contracted volume] and others are for goods to be delivered in one shipment

I have attached a cut down version of my dbase model with one completed process added into the tables. A Purchase order is placed with BORDAS - Ref No 080000, PO_ID 51. This PO has two lines on it for two different fruits different quantities but they are to be shipped throughout the year in...

I have attached a cut down version of my dbase model with one completed process added into the tables. A Purchase order is placed with BORDAS - Ref No 080000, PO_ID 51. This PO has two lines on it for two different fruits different quantities but they are to be shipped throughout the year in...

OK At some point today I will repost the DBase File with just the required data in the file to map the process from start to finish complete with descriptive comments in the tables. Many Thanks

Hi Mike The storage location would have the PO quoted on the the call off document before stock arrives, the storage facility only need the PO to put it on their Goods In paperwork provided to us after receipt, the store book the stock in on their own system using our product codes. Basically...

Hi Mike Fruit is stored off site either frozen, chilled or ambient depending on what it is. I didn't show these tables on the original relationship diagram. Please find attached v2 schema. Tables XPO x 2 are 3pl storage destinations.

I will take your points on board and review the Primary Key and syntax for table names. Most of the data has been imported from Excel but I will put in descriptions for Field Names and include all tables in the relationship window going forward. The Recipe table is for the next stage once this...

Hi jdraw Thank you for your reply. I understand that normally data isn't entered directly into tables, I was entering test data to make sure there were no issues in the relationships. The process. At the beginning of each fruit season we place contracts [Purchase Orders] to cover our...

Hello I have been creating a database to help manage call off products from suppliers and until now I have built a structure that works, as far as the flow of data is concerned. I am able to enter all the data directly in the tables cascading down from entering a PO with a Supplier to Calling...

Sorted it.

Hi I have a Main Form that has information about contracts, one of the fields is ContractQty, linked to this is a subform based on a query that enters receipts against the contract and in the subform footer there is a field that totals the receipts. What I want do is display the contract...

Thank you all very much for your help. Settled in the end to run an update query to complete the samples and then another to reverse the process if any of the criteria wasn't met. Probably not the most elegant solution but it seems to work. Thanks Again Nick

I have two tables called LabSamples and Results that have a 1 to Many relationship using a LabSampleID field. Each LabSample can have many Results what I want to achieve is for the Status field in the LabSamples table to be updated from "On Test" to "Completed" once all the Results for that...

Hi Please find attached .jpeg of relationships and LabSample and Result tables. The stages are looked up in the Test Stages table

Hi everryone I am working on a system for recording lab sample results, so far I have created tables, forms and queries to input the data and this works OK. What I would ideally like to do now is create a query to list all the samples that are due for reading to be listed in order of...

Hi Everyone I am having difficulty getting a text box to update from a combo box selection on a form. The cbo is called Stage1 and the text box is called S1LengthDays, both are fields in the same table. I am getting an error message in the code window. "Compile error. Method or data method not...

Hi Everyone I am currently working for a Jam and Marmalade manufacturer in Manchester, UK. Occasionally I need to use access to help with my role as a planner / materials scheduler and although I am fairly OK with the basics I find that I need some help with vba and more complex functions. My...