K
Ken Rainforth
Hi,
I would like to connect a form to two databases. I will give you the scenario;
It's for a retail shop, we have customer damages. We want to record these on
a database. I have SQLExpress 2005 installed which contains 1 table which
contains fields like Name, Date, Time, Customer Telephone.
The items themselves are held on our Retail Management System (MRMS) in SQL
2000.
What (in my head) I would like to happen is our customer services guys type
the general information into the form (connected to my SQLExpress DB) but
when it comes to the item (connected to my MRMS SQL2000 DB) I want them to
just type or use a drop down box to select the product item. This would then
fill all the other fields in - Price/Discount/Item Description etc.
When I load the form it says there is not enough memory to load the form. I
think it's working correctly it's just I think the form is trying to bring
down all the info about items in our store - 65,000 worth.
Is there a way for the form - only when my querie is sent - to get the data
to populate the fields or am I thinking on the wrong lines totally?
Also, the information from the form I want "saving" to the SQLExpress
database and not to affect the main MRMS SQL 2000 DB.
Any direction here would be appreciated.
Regards
Ken
I have designed a form which will connect to both of these databases but
when I try to p
I would like to connect a form to two databases. I will give you the scenario;
It's for a retail shop, we have customer damages. We want to record these on
a database. I have SQLExpress 2005 installed which contains 1 table which
contains fields like Name, Date, Time, Customer Telephone.
The items themselves are held on our Retail Management System (MRMS) in SQL
2000.
What (in my head) I would like to happen is our customer services guys type
the general information into the form (connected to my SQLExpress DB) but
when it comes to the item (connected to my MRMS SQL2000 DB) I want them to
just type or use a drop down box to select the product item. This would then
fill all the other fields in - Price/Discount/Item Description etc.
When I load the form it says there is not enough memory to load the form. I
think it's working correctly it's just I think the form is trying to bring
down all the info about items in our store - 65,000 worth.
Is there a way for the form - only when my querie is sent - to get the data
to populate the fields or am I thinking on the wrong lines totally?
Also, the information from the form I want "saving" to the SQLExpress
database and not to affect the main MRMS SQL 2000 DB.
Any direction here would be appreciated.
Regards
Ken
I have designed a form which will connect to both of these databases but
when I try to p