Form error: Join Key not in record set?

[Andrew_Duffy]

Hi,

I'm doing a small database project for University and have stumbled upon a problem with my form. I'm doing a form which takes in all the necessary fields from 5 tables (it's a form with a subform). Part of the form is composed of two tables. Lets say Table A and Table B. There is a field that appears in both tables. Field A. When I include Field A from Table A, there are a couple of fields, from Table B that I can't fill in (they give the error "Join key of Table B not in record set"). When I include Field A from Table B, they give the error "Join Key of Table A not in record set".

I'm really lost as what to do. I really want the form as it is, as I'm going to make it the entry form for the whole db. I've uploaded the db to my website
www.btinternet.com/~andrew.duffy/db2.zip

If you do download it, the form I'm using is "Player Entry Form" and the problems are with the fields in the form where you enter player's names.

Thanks for any help, I really appreciate it cuz I am getting very frustrated. It's not something I've seen before, and I'm off Uni for 3 weeks (and I want to get all the assignment finished before I go back)

Andy

 

[MarionD]

Hi Andy,

I had a quick look at your DB. I think that you might have to change the DB design a bit. What you are trying to do is enter a 1 record into 2 tables at the same time just by linking the files. This won't work. You need to keep all the Info for a player in one file - not two with the same key. It's duplicating Data and will always lead to problems in the long run. Also, you have used "Union" as a field name. This is confusing you query which is trying to execute a union query, hence the join key.... error message. If you like I can adjust your DB a bit - shall I? If yes, please post your E-Mail

Marion


[This message has been edited by MarionD (edited 04-11-2001).]

 

[Andrew_Duffy]

Hi Marion,

Thanks for the reply, and the offer of help. my email addy is andrew.duffyREMOVETHISBIT@btinternet.com

The way I set the tables up, was because of the normalisation I did. It never crossed my mind that I might have to put some info back in together (which it should have really).

If you have the time, I would appreciate if you made the changes you mention, and mail them to me, so I can see what it was and how, etc.

I will change the "Union" field to "Union Member".

Thank you =)
Andy

 

[Rohit0012]

Hi im having the same problem as Andrew Duffy however mine is taking it from 3 tables
any help would be greatly appreciated

 

[sanousy7]

Hello every one

 

[Alex2015]

Anyone answer this question yet? I'm having the exact problem.