User Profile
Aaron1040
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Cascading combos, filtering or something else
Hi all Hoping for some advice or to be pointed to the correct terminology so I can research further. I have a table of equipment, each of which can have multiple suppliers and also have multiple attachments. I’m looking for a way to firstly filter by the specific piece of equipment (always one selection) then filter by attachments (typically multiple Selection) which should leave me with only the list of suppliers who can fulfil that requirement. Thanks686Views0likes1CommentSimple database setup
Hi all I am new to Access and have watched A LOT of tutorials on YouTube. Im hoping there is someone out there that is willing to help me create my first database and get it up and running 🙂 I’m trying to achieve a plant and truck hire database, where I’ll keep a record of (tables): - Site Supervisors (employees); - Contractors (suppliers) - Contractors plant and trucks (inventory); - plant and trucks master classification (each product is classed into a specific group), eg machine capacity; - Contractor insurances; - plant and trucks attachments; - Confirmation orders (effectively, what has been hired, by who, for how much etc). I’m struggling with linking the tables correctly and then understanding where I actually enter new data, from what I understand, I am best to create forms? Eg. One to create a supervisor, another to add a new attachment to a piece of Plant and so on. Then in terms of reports, I’m looking at what insurances are coming up for renewal, viewing what orders have been issued and whether we’ve received the required documentation prior to finalising the order eg timesheet, invoice etc. Happy to discuss in further detail 🙂 thanks for reading1.4KViews0likes4Comments
Recent Blog Articles
No content to show