Product Information database

[Beany]

Hi,

Ok, im designing a new database, which is a product information database.

Customers are given PC's, Mobiles and cameras, i want to use this database and keep track of these items.....

I want to show the user name and all the details below his/her name in a table format.........

so it will show me the PC we have given him, camera details (if given) and mobile details.....

anyone got an example i can look at????

thanks

 

[BarryMK]

Hi,

Ok, im designing a new database, which is a product information database.

Customers are given PC's, Mobiles and cameras, i want to use this database and keep track of these items.....

I want to show the user name and all the details below his/her name in a table format.........

so it will show me the PC we have given him, camera details (if given) and mobile details.....

anyone got an example i can look at????

thanks

No need to shout!

The Access asset tracking database example might be a good place to start. I adapted it to suit our needs with only a little work.

 

[Beany]

sorry mate, i wasnt shouting, just making the most important request obvious.

 

[Beany]

sorry but i cant seem to find the Access asset tracking database. i must b blind.... you know where it is?

 

[BarryMK]

sorry but i cant seem to find the Access asset tracking database. i must b blind.... you know where it is?

Usually come loaded with Access as templates. Try file new first then do a search on your pc for mdz files. If you don't have it I can create a blank for you in 97 or 2003.

 

[Beany]

if its ok with you, can you please create me a blank one?

thanks

 

[BarryMK]

You didn't specify so this is 97. It has MS sample data in and dbase help too.

 

[Beany]

thanks mate