Struggelling with Access. Database setup

P

Pete

I am trying to set up what should be a very simple database, but am
struggeling with access (2003), been a long time since I last played with a
database.

Ideally I want to avoid coding as much as possible?
I need.

1) Ability to set up an customer account (invoicing address).
b) The ability to add multiple delivery sites as required, linked to the
invoicing address

2) A second form to assign a piece of equipment to a site (i.e model &
serial number). You should be able to enter the account number and/or
company name, which will bring up the company details (combox?? i.e invoice
address is shown, and option to select site (if applicable) which should
then should display the equipment on site with the option to update the data
as required)

Any suggestions on how to acheive this? I assume this is quite
straightforward? The rest is then reporting which should be simple enough?
Any chance someone can point me in the right direction to acheive this? or
even (being cheeky!) knock something up to get me on my way? (email
(e-mail address removed)) - remove spam!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top