advanced access training - MORE buttons on a form

HI

Thanks for phoning in, it made what you were trying to achieve must clearer. What you need to do is to have:

Order table
Item table
OrderItem table

Item table: contains a list of all items that can be ordered along with ID etc

Order table: holds all of the details about the order, however not what has been ordered.

OrderItem table: holds all information about the items ordered for a particular order.

Then in you order form - you have the order details at the top and then you are able to have a sub from for the orderItem as it is now a separate table. Thus orderItems are linked to an Order. So you sub form can be just a simple table format, which can have 1 or many rows.

Hope this helps

David