Database advice needed

[TEAK36]

Can anyone recommend a database similar to Microsoft Access? It is something I want to use for the Goods In dept at work, so I don't mind paying for it. We are currently using Microsoft Acees, but have had nothing but problems with it, and I would like to see if there are any alternatives.Basically, I want to set up a Goods In Template where everything that is typed into the document is automatically stored in some sort of summary spreadsheet, for example, If I receive 10 of part X from Customer Y, on date Z, the summary should show this. I want to be able to click on a particular line of the summary, and for the relevant document to open up.Also, all of our Goods Receipt Notifications need to be issued with a unique identification number, even if it was something simple like GRN1,GRN2,etc, and the software needs to automatically select the next GRN number.
Any advice would be most appreciated.

[kujawski]

why not write an application?

[OBonio]

What problems are you having with Access? This is the most apt application to use for this I reckon. You could also use Excel, but Access would be my choice.

As for unique id number, in Access this is usually the AutoNumber field type. In SQL Server we use something called a GUID (Globally Unique IDentifier). You can also use these in Access apparently :

http://www.access-programmers.co.uk/forums/sho wthread.php?t=108630

AutoNumbers are easier to deal with though. And, as the name suggests, they automatically increment when a new record is created.

[chazza]

I used to work in database design and we used Foxpro.

I believe Microsoft Works also have a similar database function

[OBonio]

PS, if you want any help with the Access database, email me<a/>.

[OBonio]

Grrr.... wish there was an edit thing in here!

Email me

[big flywheel]

if you follow the following link, you might find it useful as i'm looking for a handy database myself and came across this, though i haven't done anything about it yet. Hope you find this useful and don't be put of from watching this just because you the title "you tube". https://www.youtube.com/watch?v=DOkT5gIil9I&mod e=related&search=

[wideboy]

What about Open Office? I think they have improved their database section now?