Data entry into many related tables

[Matej]

I have a data model which includes five inter-related tables - it's a common task of connecting customers, orders, items, order details and employees.

When I need to enter a new order I have to enter different ID's into different tables i.e: into table Orders I have to enter ID_Order,ID_Cos tumer and ID_Employee, into table OrderDetails I have to enter for each item ID_Order and ID_Item...

And also, when I enter those ID-s, I'd like to select them from the lists. Do you have any suggestions how to do this?
Thx

[TheSmileyCoder]

Hi Matej and welcome to Bytes.

If you use a good setup of forms, alot of this information will be entered automatically, by using linked/embedded subforms. I would recommend browsing through the Northwind training database that comes with access. It shows alot of such details, as well as how to setup comboboxes to get dropdown lists to select from. If you still have more specific questions after looking in Northwind, please feel free to return.