Database Concern - Issues figuring out design using many important group break downs.

[bsbllmaster06]

Greetings,



I've always been interested in messing around with VB, C++, Java ect.. throughout my days.. I don't get to use any of my college credits for my profession, but every so often I enjoy starting a project and seeing where it goes.

Right now I'm working on a program that potentially needs a massive database and I am not sure how to even start building it.

My thought is simple, but the design I feel might be too complex.

Imagine a list of clients. (clients 1 - 9). Each client can have specific Group of Services (Services A-F). Inside each service there are specific charges for line items (line items 1-10), and each price differs per client (for the same line item).

I'm trying to figure out how to connect each together via Access so that when options are selected in a program the program will spit out a $$ based on Client - Package - Line Item.

Example - Client 1 - Purchases Group A - But only needs Line Item 3 to be invoiced to them.

Two Minutes Later

I need to pull - Client 2 - Purchases Group A - But only needs Line Item 3 to be invoiced - (pricing different than what was invoiced to client 1).

Any idea on how to start this? Once I get it going I can troubleshoot from there.

[orange]

I'm suggesting you work through this tutorial
http://www.rogersaccesslibrary.com/T...lationship.zip

[bsbllmaster06]

Perfect. I appreciate it. Refreshes many things and fills the gaps.