Tables problem in one-to-many relation

[petko]

Unfortunately I had to modify a database quite deeply due poor design.
I had a table (Table A) that was used on its own before. I had to define a new table (Table B) and between them establishing a one (Table B) to many (Table A) relation. Some values were copied from Table A to Table B. A sub run through the records of Table A and filled up the link field with the apropriate value from Table B.

I did thing like this before with Access 2002 with no problem.

Now the tables and link work fine but if I use both tables in any query, things painfully slow down and I don't know why. Opening the query might take a minute but if I remove all field either from table A or table B speed comes back.

Can anybody help what went wrong?

Thanks in advance.

Peter

 

[pr2-eugin]

That sure is bizarre, how many records roughly are there in your tables? Can you show a screenshot of your relationships? Or show how your tables are structured?

 

[petko]

Dear pr2-eugin

Here I'm attaching the screen shuts of both tables' structure and the relation.

Kivétek (many side) has 14 000 records at the moment.
KivetekRaktari (one side) has 3 300 records.

Can you see something? If you need any further info or translation, please let me know.

Peter