View Full Version : Join tables


ranen
07-11-2005, 02:00 PM
HELP!!! :confused: I do have a 5 tables 4 tables do have a foreign key of the main table. I join the 4 tables with the main table but when I am editing the information I cannot edit it. and no error appears. so I am just wondering what happen with my joined tables? please help me!!!!Thank you in advance

Pat Hartman
07-11-2005, 06:27 PM
Sounds like you have four independent 1-many relationships. You cannot include more than 1 1-many relationship in a query unless the relationships are hierarchial. Use a main form with subforms to manage the many-side data. Use a tab control if you need more real estate.