Hi all,
I want to make a report in my database that would include all fields in a table, but not sure if it's even possible.
So basically, we deliver large items out to people, and sometimes they also want what we call 'ancillaries'. The ancillaries are listed in a table (tblAncillaries) and are allocated in another table (tblAllocatedAncillaries) which is connected to tblDelivery using DeliveryID (PK of tblDelivery), which in turn in connected to a client details table (tblClientDonorContact).
I want a report that would be printed everytime anyone wants ancillary items containing some of the details of the client and then the WHOLE list of ancillary items, not just the ones that are allocated to them. This would all be connected using DeliveryID. The reason why I want all of them is because they are likely to add items on to the list after the delivery is set in place and I don't want to be printing off a new slip after they change everything each time. Also it helps with packing up the items if they have all the items on the list (don't ask me why, it's how it's been requested!)
How would I go about this? I have thought about manually writing up the list of items using labels and then using IIf functions and dlookups, but that would result in a very slow form surely, take a lot of time to create and also be fairly longwinded to change if the list was to ever change. I'm open to ideas!
Thank you in advance.