Can't type in form anymore

[sbuckingham25]

I don't know what happened. I changed the relationships in my query attached to my form because I was getting a "one to many" error when I selected from a list box.

I changed the relationship to go from "ID" to "ID" and now I can't type in the form at all.

Help!!

 

[boblarson]

You probably joined two autonumbers - that can't happen.

 

[sbuckingham25]

Now I can type inthe form, but can't select anything in any of my list boxes. ????

 

[sbuckingham25]

I wanted to refresh this.

 

[boblarson]

Can you post the db?

See here for how: http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[sbuckingham25]

Oh, never mind, I got it. Thanks for your help!!!

 

[sbuckingham25]

My problem database :-0

I am having major Relationship issues.

 

[georgedwilkinson]

You have a join on a column that is Number in one table and text in the other (TechID). You need to fix that.

Probably not related to your immediate problem but this database is not normalized. It really may not matter, depending on what the system does.