Search results

plog Thanks for your help. What I initially had, and what you mentioned above in relation to the 'Thread' table is working perfectly. Mainly through program code, messages are sent/replied to quite nicely. Thanks for helping me along my quasi-suspicious restricted path.

plog, would you mind clarifying this please? When a new record is inserted, the program will add the new line to 'Messages', but if 'ThreadID' is a foreign key, won't this line need to be added beforehand? If so, will I then need to use @@Identity to get the ThreadID from 'Threads' to...

Thanks for all the information guys. Plog, I'll re-visit the table layout and include 'MessageThread'. That sounds like it will be easier to manage programmatically too. I understand this is far away from what a real solution should be, so I'm very grateful for the help.

Thanks very much jdraw. I'll take a good look at that link - appreciate the thought. Out of interest, what is your opinion on what, at the moment, seems to be a viable solution that plog has been kind enough to discuss?

Thanks plog. Would the query have to act in that way? Could the same results be achieved by looking for anything with the parent ID, which is then sorted by date/time to get the most recent?

Thanks very much for the helpful response plog. With the MessageArchive table, the rationale there was to move messages from the 'Messages' table to this table after a period of time (or maybe if an additional 'Status' field were added where you can 'Close' down the message, and therefore...

Hi folks Thanks for the responses (rebukes?) :) On a serious note, the restrictions I've stated are there. Whether it be strange or not doesn't change anything... This tool is nothing really much more than a trial to link multiple areas by providing a basic tool to communicate with. As it...

Hi GinaWhipp Thanks for replying. Even though that's the case, is the premise not transferrable? (Not a rhetorical question!) An existing VBA app within Excel is what contains forms that will send the information into the database. Another form will be used to view the data. Next...

Thanks for the input so far. The solution I'm after is the solution I need. Whilst I appreciate the mention of alternatives, if they were viable, they would be used. If I'm honest, even if alternatives were available, I'd still be asking the same question in order to further my...

Hi jdraw, Thanks for the reply. It's for a couple of reasons really: Where I work, there is no Outlook for nearly every potential user. My database knowledge is slim, and I'd really like to get my head around this kind of thing (though that isn't the motive). The link for the...

Oops - didn't realise it hadn't uploaded! Thanks for point it out moke123.

Hi all Being new to databases, I feel I'm jumping in the deep end here, but here we go: I need (yes, need) to create a database that allows: Messages to be submitted to from a user to another user (each user will have their employee number loaded in already as their 'UserID' in the...

FYI anyone who's interested! I've made a disgusting looking mock-up of how the application will submit data to my troublesome database will work in an effort to support what I've written so far about it. The terrible drawing alludes to the fact that: Users can choose one of the...

Thank you Minty. The_Doc_Man. Minty, based on what we've discussed so far, and taking into account what you stated about the parent solution being a moot point if my database is only acting as storage (which it is), is this, in your opinion, the best path to go down? This isn't me...

Thanks very much pbaldy.:) Very kind of you to offer maths tuition Galaxiom, though my joining is purely for Access support! Those who decide to abstain represent a null value in my heart; I prefer to go by the decision makers' percentile, its consequences notwithstanding! Cheers...

Understood... Is what I'm doing breaking some known rule of database use? Is it the case that I have to succumb to including the level1, 2,3 data in the same table when each new submission is made? Naturally, I'll end up with duplicates because the choices are limited, but all will...

Ok Minty... I kind of get what you're saying. I'm getting into using 'Paint' today so I've attached another screenshot. I don't quite understand the parent side of things (looking now!) and how this will tie into my existing data, albeit your mentioning of a foreign key for...

Hi Minty Thank you for the reply. I have taken some screenshots of each table, and the relationships window to show a blank canvas. Just so you're aware: the tables in the screenshots only contain data focussed on if a user - when using the application containing lists just like those shown...

Hi Informer I just typed about a complete response only for my work network to crash and lose it! I'll be honest, I've never done a CDM or PDM. I am a person who has used Excel, which has served me completely until now, but that does mean I'm a bit of a newbie when it comes to databases...

Hi all I looked to make sure I shouldn't be posting this elsewhere, and this seems to be the right place, I think. I can't find anywhere that really puts a direct answer to my question, though it may be somewhat down to my lack of knowledge. Here is my situation: I am creating a system that...