Creating an inventory system using Access.

[Jeffrey55]

Hi all,



First of all, I have no idea where this should go. Mods, feel free to move this wherever you see fit.

So I'm trying to create a system for work that will pull information from an inventory table and a customer table and put it into an order table along with some information that will only be in the order table. Specifically, I want to have a form where someone puts in the customer name and item numbers to be ordered and it puts all of that into the order table. I know this violates normalization rules, but I need to use this information for work orders and invoices.

Now it gets really fun.

I need a form where I can add the customer information and the item information for multiple items and the the customer information will appear in the record for each individual item.

If anyone knows of any good resources for doing this kind of thing, please let me know. Thanks for all of the help!

[rpeare]

Is there a specific question here or are you looking for a pre-built database?

If you're looking for a pre-built/template database look for any purchase order database this is a pretty standard thing you're doing.

If you have a specific question what is it? is it about data structure?