Database Design

[StuJol]

Can someone help as ive been thinking of a way to design a part of my
database and can not decide if it will work.

What i want is a record of different suppliers in the view of a form with
specific data in. I want the form to show the current account balance with
that supplier. I also want to be able to make a payment to that supplier and
for the current account balance to reflect this. i also want to be able to
view a history of payments.

Whats the best design to acheive this. Been looking at templetes but cant
find anything similar

 

[Roger Carlson]

Look here. They're data models, not templates, but there might be something
you can use.

http://www.databaseanswers.org/data_models/index.htm

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L