Using Form Query to Load Multiple Tables

L

Larry

My Database has a main table with 24 linked tables to it.
A form is used to add the base information alonh with updating each table
with a reference number. (Donor is automatic as it is the key) So when user
presses the Add Key an completed entry is made to the main table as well as
an entry, in each of the linked tables, for the donor and reference numbers.
Main table consists of 9 fields that relate to a donor.
Form uses a query to load the data in the main table and load the reference
number in each of the linked tables. Form worked fine when updating the main
and 15 linked tables. I have the need to add more tables and when I do the
database locks up. I have looked to see it ther is a limit as to number of
entries allowed in a query but have not found the information I need.
Can someone tell me where to look or give me a clue of how I can resolve
this opportunity? This has been bugging me for the last several days.
 
M

M Skabialka

The maximum length of an SQL statement using RunSQL is 255 characters. You
may have the same limitation depending on how you are defining the control
source.

You can shorten the number of characters in a query using code similar to
these:

SELECT tblEmployee.EmployeeID, tblEmployee.LastName,
tblEmployee.FirstName,tblEmployee.MiddleName
FROM tblEmployee;



SELECT e.EmployeeID, e.LastName, e.FirstName, e.MiddleName
FROM tblEmployee AS e;



SELECT emp.*
FROM tblEmployee as emp;



Mich
 
L

Larry

Mich,

Opportunity resolved.
Thanks

M Skabialka said:
The maximum length of an SQL statement using RunSQL is 255 characters. You
may have the same limitation depending on how you are defining the control
source.

You can shorten the number of characters in a query using code similar to
these:

SELECT tblEmployee.EmployeeID, tblEmployee.LastName,
tblEmployee.FirstName,tblEmployee.MiddleName
FROM tblEmployee;



SELECT e.EmployeeID, e.LastName, e.FirstName, e.MiddleName
FROM tblEmployee AS e;



SELECT emp.*
FROM tblEmployee as emp;



Mich
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top