WHICH COMES FIRST?? FORM OR TABLE?? 2

[LMHODNETT]

I am trying to build an application to use in our store for taking special orders or requests. The application has three databases that are used. One is for EMPLOYEES, one for CUSTOMERS and one for SKU wich is the data abour the pattern. I want to build a from for entering data for a spceial order and I need for this to be store in another table called ORDERS. I have the form built and mostly working. My problem is the data entries are not all being store in the ORDERS database. As you may expect, much of the data in the form is a result of data being pulled from these other three db's using combo and text boxes. The combo box data is what I am having a problem saving into the ORDERS table. The CUSTOMERS DB and the SKU DB contain much data that is need in the ORDERS DB. Each of these db's can contain up to 10 data files that are needed to make the ORDERS table complete. Can anyone give me some insight on this problem??

Thanks,
Larry

 

[ssatech]

Have you looked at the Order Entry Example as an idea in where to start:

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT011366791033

 

[Remou]

I suggest you link all the relevant tables or use queries to get the data. Here is one thread:
Can a form access tables within different databases?
thread702-1215072
It seems that you have quite a lot of databases, though.

 

[mrluck]

I want the cancel button to close the form and not the data to the table either.

 

[Remou]

Can you explain a little more?