Recent content by Dansam

Hi, the database has a number of table in it, but I am only generating the report from one (sub reports already in there and working correct) The year field has more than just one field in it, for example for member name = Jon Smith, Year Joined = Secretary (2010), Year Left = Secretary (2020)...

Hi Mike, no I can't as there is personally identifiable data within it

Hi everyone in the forums Not sure where this thread needs to go, it falls into a number of camps I believe! I have built a database and got all the functionality working (importing data, updating the system etc.) and now come to a head scratcher with the reports which is my least favourite part...

Thanks Pat, yes I have a skills proficiency table and the function was working, just running test data through the DB to see if I need to rebuild that

Thanks @Pat Hartman, I changed the design so that skills and interests are now in a single table and that makes it much cleaner. Sometimes I get so close to these things that I don't think about simple design changes that will fix the problem!

So here's the structure: In the form I' like a user to select a hobby or occupation (or more than one of each), click a button and the OccupationThemeID or HobbyThemeID field is updated in thier respective tables, so a Theme can have multiple hobbies or occupations associated with it. Now this...

Thanks @Pat Hartman for the feedback. I have a table 'Themes' and want to add skills and hobbies to the theme (e.g. Travel Theme could have skills Mechanic, Panel Beater, Pilot and interests Vintage Cars, Sailing) I wanted a simple interface to list the skills and interests and update them...

Thanks MajP, that works a treat, and now all I have to do is write the code to do the update... o_O

So currently the theme ID in both tables is set to 0, what I'm aiming to do is select items in the list box and run an update, relating the list entries to a theme in a master table.

The ID field here is not being used for anything in the list box, it is just for display.

The HThemeID and OThemeID are fields used to link the one-to-many relationships, they're double values in a number field in the repective tables

Thanks but that just creates a 4 column list, and too many entries! I'll edit the OP and see if I can explain myself more clearly

Something I was thinking about (just to make my interface easier) I'd like to create a listbox with data from 2 tables (tblOne and tblTwo) tblOne has fields HName (short text) and HThemeID (number, used to link to a master table in a relationship) tblTwo has fields OName (short text) and...

Thanks for the advice and pointer, it was a very simple solution in the end. I created an update query using LEFT JOIN (import table to live table) that updates existing and imports new records. Helped me simplify a number of import functions and cleaned up and reduced my modules :)

Thanks all for the advice, I'll have a look at the options and see which works best :)