programing

[Guest]

Okay i'm looking to create a database for deliveries. I want the deliveies to
go by projects. I am learning and i was hoping for some feed back.
I created a table for customers, projects, shipping comapnies. Now I created
a table for the deliveries which will pull information from all these areas.
and also forms for all these things. I want to be able to put in multiple
items for each delivery do i make a subform to hold this information and how
do i connect it to other tables?

 

[Jeff Boyce]

Have you searched at Microsoft or via Google for a template you might be
able to adapt?

Before you design any tables or forms, shut off your computer and pick up
paper & pencil.

What "entities" are you going to need to track data about? For example, you
will probably (only a hunch) have customers, things (to be delivered), and
ways to deliver. In YOUR situation, are these true? Use your paper/pencil
and jot these down.

What "relationships" exist between these entities? Can a customer have more
than one thing delivered? By more than one deliver method/provider? For
example, in an order processing system, an order can consist of one or more
order items but the fulfillment system may not be able to ship all items in
an order at the same time. Only YOU know what's true in your situation.

Do you have any relationships you could characterize as "many-to-many"? For
example, in an order fulfillment system, one customer can order many items,
and one item can be ordered by many customers. In this situation, using a
relational database (e.g., Access), you'll need to create a
"junction/resolver/relation" table between the many-to-many tables. This
junction table will use one row per each customer/item combination.

If what you are describing is something like an Order system, check the
Northwind database that comes with Access as a sample/example.

Good luck!

Jeff Boyce
<MS Office/Access MVP>