Recent content by NickFazer

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