Search results

I have a pop up form that displays delivered products. This form has a button on it that allows the user to re-deliver some of the product which has been rejected: The user needs to select the product they wish to redeliver and then press the "Reject Product" button. This will then open a...

just to update: resolved this myself. probably not the most elegant of ways of doing it but at this time without much guidance it works and gets me to where i need to be so elegance be damned. The process works as follows: User opens a consignment record and is presented with available...

Please excuse the title of this thread, i'm not entirely sure it makes much sense but i was trying to convey the purpose of the question. Below describes the process i'm trying create based around current processes and the table and form designs i have so far. The current process is used with a...

@jdraw i'll have a think about what you've suggested. i'm not sure i've explained myself well enough yet if its not clear what the process/scenario is as tbh i know what is required for the process/scenario and believed i'd described it fully but i'm guessing i have not. i can't provide copies...

@jdraw thank you for your efforts it is really appreciated and i see where you are coming from with the diagram but it leads to the question i think i'm wrestling with and that is: I need to be able to display all the ProductInDelivery for multiple consignments and have a data entry field that...

reading a bit more into things should the Delivered Product allocation use some sort of temporary table generating records when the form is open pulling data from multiple tables including the amounts already written and the write the data back to the actual table for any records where the user...

i will try and give more detail and see how we go. there really isn't a "day in the life" as things can take both weeks or hours with the changing nature of the deliveries. Consignments Consignments are made up of multiple amounts of fruits (products) packed into a container and put on a boat...

So FACT-DeliveryProducts is the many-to-many for the products: the field naming is kind of a hang over from my development days of documenting code with good naming the yes/no is hangover from my initial misunderstandings of display vs stored data, i will inevitably remove it but it was there...

my specific questions are: I think I need a X table that has an amount for each delivery linked to Invoice/Consignment/Delivery/DeliveredProduct tables, but not sure How do display a field to enter data into without creating records in that X table until a user enters values in field I was...

Here's is my table design and relationships as it stands right now. slightly simplified as there are a number of dimension tables with constant data used by a number of the tables that i've not included: as an example of the dimension tables: happy to supply more information if you need it

@jdraw thank you for your feedback it is appreciated and whilst i'm not one for expecting someone to do the work for me i really need some pointers as to what i've described above and the possibilities of what i want to achieve. i've done a considerable amount of table design work and tried to...

The project i am working on is to migrate the company business from a excel spreadsheet into an access database to improve data quality, data consistency and improve the multi user experience as there are now 4 people continuously updating and using 1 HUGE excel spreadsheet which is creaking...

i actually think this - https://stackoverflow.com/questions/33245849/create-multiple-records-in-one-form-only-one-field-changes-per-record - covers everything i need, it even shows a way to show NO records when the form opens by finding the latest record and making the filter be 1 more than that...

ok after reading a bit more i think the following might be the right way to do things: Form bound to invoices table showing no records A number of unbound fields for the general information Button to generate a number of records based on the list of consignment IDs passed to the form as a...

This might be a bit of a ramble but i am going to try to describe the form/query i am trying to create. Consignments have invoices from multiple sources attached to them using consignment_id as foreign key in the invoices table. There is a need to be able to select a number of consignments and...

@arnelgp just to update, i have adapted it to my needs and it works brilliantly thank you so much for your help it really helped me re-asses what i was doing and how i should do it and will help me going forward as i am going to have to do more of this in different areas so i'll re-use this alot

@arnelgp thank you i think this has given me all the tools i need to create something that works for me from your suggestions, i need to plan how to adapt it and may come back with any further questions but for now i think i have everything in those 2 examples to get to where i need to be

@arnelgp awesome, downloaded and looking now

@arnelgp this is (almost) exactly what i need. a little extension that if you can give me some pointers on i'd appreciate it. Currently the form i have has "Customer" "Supplier" "To Date" "From Date" filters that show the records i want and then i want to be able to: - Select individual records...

@arnelgp thanks for getting back to me, i'll take a look at the demo and see if it solves my problem, sounds like it might though