[Solved] Form from 3 tables?

[Scott]

I am new to open office, and i have never done anything with database's. I have used base to make several tables and forms to put together a database that will make price lists for the produce i sell. I also have a table that stores the customers i have. What i need is a form that will allow me to enter the orders for the different customers based on the items i offered that week on the price list. Then i will use that data to make the customers invoices in sun report builder. I have a table with customers. I have a table with the items i offer, that is also where all the vendor and pricing info is to build the price list report from. I need a form that displays the item offered and has a place to put in numbers for the amount ordered to store for making invoices. And it needs a way to associate the order data to the different customers in the customer table. I have been trying to set up forms and sub forms using different ideas but nothing worked.

[r4zoli]

For starting point check Brian's Book dealer example.

[Scott]

This looks promising i am working with that book dealer db now to see what he did, but i get an error when i try to use the "print invoice" button. the other macros seem to work fine so far.

[Scott]

never mind i found the cause of the error the ide hilighted a line in the macro that had a space between "Book" and "Dealer" i took the space out and all is good.