one form to many tables

[jonathanjilla]

Hi all!

my access database consists of many tables, one for each business location. A record in these tables will hold information such as sales by category, inventory, cash total, credit total etc. I have a form for each table to enter the data.

my problem is when it comes to recording deliveries. I could just enter them on the form where I enter the sales, but I need to enter them for all locations through one separate form for deliveries only. I will need to be able to select the appropriate table when entering the delivery. This is the part I do not know how to accomplish.



Thanks for your time!

[orange]

You would not have a different table for each business location.

suggest you read through this article.
http://forums.aspfree.com/microsoft-...es-208217.html

[boblarson]

Just an extra voice to say that your design is flawed and not normalized and should be fixed before going any further.

And another article:
http://support.microsoft.com/kb/283878