On Oct 20, 2:36 pm, KARL DEWEY <
[email protected]>
wrote:
Remove the suffix '1' from Orders table name.
--
KARL DEWEY
Build a little - Test a little
:
On Oct 20, 12:42 pm, KARL DEWEY <
[email protected]>
wrote:
In you Orders table what are these field names -
Lookup To Banks Lookup To Currencies Lookup To Order Types
If you open the table what is the data stored in these field?
It should look something like this --
1 2 2
2 1 1
2 2 1
and not as you posted --
BOO GBP/USD Sell
AVM EUR/USD Buy
--
KARL DEWEY
Build a little - Test a little
:
On Oct 20, 9:29 am, KARL DEWEY <
[email protected]>
wrote:
Your memory problem stems from your query is not relating tables --
FROM [Jan 2008], Currencies INNER JOIN (Banks INNER JOIN ([Order....
[Jan 2008] is not related and therefore give a Cartesian effect. That is
where all unrelated table record quanity is multiplited by all other table
records.
Post sample data from each table.
--
KARL DEWEY
Build a little - Test a little
:
On Oct 17, 9:24 pm, (e-mail address removed) wrote:
On Oct 17, 3:35 pm, KARL DEWEY <
[email protected]>
wrote:
Then I have 3 parent tables called currencies, order types, and banks
I think part of my confusion might be with how exactly how the relationship between my parent and child tables work.
Let us clear some of the confusion.
If you open the Banks table it will probably look like this --
xxID Bank
1 Some National Bank of Somewhere
2 CitiCorp Bank
3 SomeOther Bank
If you open the Orders table and look at the Bank field you will see number
instead of names. The same for the other 'Parent' tables.
I have about 400,000 rows of data. Is that too much for an access database?
Usually not.
It told me that I either do not have enough temporary memory or the size of the file is larger than 2 gb...
Did you backup the database and then do Compact and Repair?
Post the SQL of the append query you tried to run. First open the query in
design view, click on VIEW - SQL View, highlight all, copy, and paste in a
post.
--
KARL DEWEY
Build a little - Test a little
I will post monday morning at 7:00 AM Mountain Time with the SQL
statement I am using. I do not have the data at home so I have to
wait until I am at work again...- Hide quoted text -
- Show quoted text -
Okay here you go...This is my SQL statement I am trying to use to
append the two database tables...
INSERT INTO Orders ( [Order], [Order Types_ID], Contract_Size,
Currencies_ID, Price, Banks_ID, [Date], [Time] )
SELECT [Jan 2008].Order, [Jan 2008].Order_Type, [Jan
2008].Contract_Size, [Jan 2008].Currency, [Jan 2008].Price, [Jan
2008].Bank, [Jan 2008].Date, [Jan 2008].Time
FROM [Jan 2008], Currencies INNER JOIN (Banks INNER JOIN ([Order
Types] INNER JOIN Orders ON [Order Types].ID = Orders.[Order
Types_ID]) ON Banks.ID = Orders.Banks_ID) ON Currencies.ID =
Orders.Currencies_ID;
Access built that for me...
I have not defined any relationships with the new data I imported.
All I did was import it and then try to run an append query. Should I
define relationships between the new data and the parent tables and
then try to run an append query?- Hide quoted text -
- Show quoted text -
I can change it to a number field...Right now it is the actual value
but the data type is a number...When I use the table analyzer it
automatically uses the actual data in these lookup columns rather than
the forien key like you suggested...- Hide quoted text -
- Show quoted text -
It is telling me:
"Enter a parameter value" Order Types.Order Types
