Recent content by MarcusL

Event Category;Sub Category worked perfectly in the query, thanks a lot! As for the good practice issue. I could make a query that contains the entire table and base the subdatasheet on that? But from what you're saying it sounds like this would still not be good practice because working with...

Thanks June - I have posted a reply to CJ_London's comment (it's awaiting moderation at the moment). Any help would again be greatly appreciated. Cheers

I'm not interacting directly with the table - I'm using a query. Can you describe how using forms would help in this case? Performance isn't an issue as the database isn't very big (just a few hundred records). The advice to use 'Category' as the child and master field is great - it would have...

Hi I have a database which records 'incidents' (ie things going wrong in my place of work). I have created a totals query (based on a single table) which shows how many incidents have been recorded for each category of incident (eg IT, suppliers, on call etc) in my database. I want to add a...

Thanks ridders. So would you recommend a separate table for each combo box in my db, each table containing the options for that combo box? And if I do this, would I still need to update all my forms to tell them to draw their combo box options from the new tables, rather than the value lists...

Hi I have a combo box field in a table (row source type: value list). I have added some extra options to the row source (in the table), but the options are not present when I click the dropdown for that field in a form. Is there a way to have the forms automatically update their value list to...