Recent content by CharlieNewbie

Cheers Way2bord, Sorry didnt see your reply, or didnt see notification, Normalisation, Thank you so much mate, I'm on it. I have to get out of Excel thinking, and drop downs etc. So Im getting the feeling all I need is an accommodation field and a services field. Then a Drop down menu for...

Hi Marla, Thank you :-) Basically of someone say visits the centre today and is sleeping outside they have an accommodation of RoughSleeper for today's visit. But say next week we can find them accommodation in a hostel the accommodation type changes to hostel for that visit, then hopefully...

Thanks Gemma, much appreciated I know exactly what you mean, thank you. Done quite alot of research. Unfortunately the charity doesn't have the cash, so will get something in place, need to learn a bit of SQL, get ahead on queries and the relationships side. As for the not the same as excel...

Thanks Marla, Hopefully this will post and make it clearer. :-) Test Attached (fingers crossed) Database Design Entities · Clients · Visits · Accommodation · Services Relationships · 1 Client can have more than one Visit 1:N ·...

Thanks John, I do need luck.:-) Yep, should have said we have a paper based system in place. Client Personal Visit Form to be filled in on first visit. Then there is a tick register taken everyday, which shows which services used, the days date and what accommodation type the client has or...

Thanks Rain, Much appreciated, just posted in general forum, so fingers crossed. :p I can see the benefits of access, but to learn it by yourself is hard work. (especially when time limited). Later Charlie

Hello All. :-) I work for a charity and have been given a task to come up with a database for our homelessness Drop-in Centre that can monitor each visitor, their personal details, visits, services they use during the visit (shower, food, medical etc) and accommodation they are in at present...

Hi All, Thought I would say hello, quick intro. :-) Just about to post in another forum, if I can work out to do that, Work for a small charity, where you have to just learn how to do things. Coming up with a database to monitor visits and services to a homeless Drop-in Centre. Sounds Easy...