Creating forms

[Guest]

I want to streamline our invoice creation operations here at work. I have
created a database of customer names and addresses. I want to create an
invoice template. How do I do that? Secondly I want the ship to and pick
address info to populate ffrom the customer database. How do I do that? I
know this is a lot to ask but any help would be very appreciated.

Best Regards,
Kelly

 

[Smartin]

I want to streamline our invoice creation operations here at work. I have
created a database of customer names and addresses. I want to create an
invoice template. How do I do that? Secondly I want the ship to and pick
address info to populate ffrom the customer database. How do I do that? I
know this is a lot to ask but any help would be very appreciated.

Best Regards,
Kelly

Hi Kelly, your idea is very good indeed, but the scope of your questions
are a bit large to address all at once.

For the customers/orders/products/invoices/invoice details piece, I
would ask "do you understand relational database design?" These are key
concepts to guide your development. The Northwind example database from
Microsoft has a good example of what you are trying to model.

For the pick list question, assuming you have an "invoice" table, you
would include a "customer" identifier that is related to the customers
table. If you build a form based on invoices, the customer details can
be fetched via a join between the tables by choosing the customer's ID.

HTH?